Friday, September 12, 2014

Enabling Archivelog mode in RAC environment

########### Do this for all nodes##########################################

ALTER SYSTEM SET log_archive_dest_1='location=<Archive dest>/' SCOPE=spfile;
ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

ALTER SYSTEM SET cluster_database=FALSE SCOPE=spfile;

srvctl stop database -d <db name>

STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER SYSTEM SET cluster_database=TRUE SCOPE=spfile;
SHUTDOWN IMMEDIATE;

srvctl start database -d <db name>

No comments:

Post a Comment