Thursday 3 September 2009

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


0 comments: