dba
archive log list; | select log_mode from v$database; #noarachivelog
shutdown immediate;
startup mount;
alter system set log_archive_dest_1='location=+archdg';
alter system set log_archive_dest_1='location=/archive';
show parameter log_archive_dest_1
alter database archivelog [noarchivelog#关]
alter database open;
archive log list; | select log_mode from v$database;
alter system switch logfile;
RAC集群
dba
archive log list; | select log_mode from v$database; #noarachivelog
!srvctl stop database -d dbname -o immediate;
exit
dba
startup mount;[只只需要在其中一个节点启动到mount即可]
alter system set log_archive_dest_1='location=+archdg';
show parameter log_archive_dest_1;
alter database archivelog;
alter database open;
shutdown immediate;
srvctl start database -d dbname;
archive log list; | select log_mode from v$database; | show parameter log_archive_dest;
alter system switch logfile;