Oracle : Archivelog mode 2

# For RAC bring down other instances srvctl stop instance -d NTPDB1 -i NTPDB12 # On remaining instance alter system set log_archive_dest_1='location=/u02/volntpdblogs01/oradata/NTPDB1/archive' scope=spfile alter system set log_archive_format='%t_%s_%r.dbf' scope=spfile shutdown immediate; startup mount; alter database archivelog; alter database open; ALTER SYSTEM SWITCH LOGFILE; # For RAC bring back other instances srvctl start instance -d NTPDB1 -i NTPDB12