How to Oracle RAC DB will into Mount stage? How to Enable & Disable Archiving into Oracle RAC?

How to Oracle RAC DB will into Mount stage?
How to Enable & Disable Archiving into Oracle RAC?


Ans: We can use normal db command for this but when are using RAC ... we have to use specific command which is being use into Oracle RAC

1) Check Current Archive Log Mode Status

Archive log list;

2) Shutdown the RAC database on each instance or simply shutdown from SRVCTL command:

srvctl stop database -d RACDB



3) Start the Oracle RAC Database in Mount Mode

srvctl start database -d RACDB -o mount


4) Set the following parameter used for enable archive log:
ENABLE
SQLPLUS / as sysdba
ALTER SYSTEM SET log_archive_dest_1='location=/u01/archive/' SCOPE=spfile;
ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;
ALTER DATABASE ARCHIVELOG;

DISABLE
SQLPLUS / as sysdba
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=defer SCOPE=SPFILE;
ALTER DATABASE NOARCHIVELOG;

6) Down & Up the Database

srvctl stop database -d RACDB
srvctl start database -d RACDB