########### 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>
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