Monday, April 16, 2012

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