Enable/Disable Archive logs in a RAC environment
on node 1:
set oracle_sid=racdb1
-------------Noarchivelog
sqlplus / as sysdba
alter system set cluster_database=false scope=spfile sid='racdb2';
quit
in command line:
srvctl stop database -d racdb -o immediate
sqlplus / as sysdba
startup mount
alter database noarchivelog;
alter system set cluster_database=true scope=spfile sid='racdb2';
shutdown immediate
in command line:
srvctl start database -d racdb
-----------------Archive log
on node 1:
set oracle_sid=racdb1
sqlplus / as sysdba
alter system set cluster_database=false scope=spfile sid='racdb2';
quit
in command line:
srvctl stop database -d racdb -o immediate
sqlplus / as sysdba
startup mount
alter database archivelog;
alter system set cluster_database=true scope=spfile sid='racdb2';
shutdown immediate
quit
in command line:
srvctl start database -d racdb
No comments:
Post a Comment