Monday 7 February 2011

Enable Archive Log Mode in Oracle RAC 10g Database

The following will be the steps:
1- Login to one of the clustered database nodes and change parameter cluster_database to false:
   sqlplus "/ as sysdba"
   alter system set cluster_database=false scope=spfile sid='racdb1'
  
2- Stop all database instances:
    srvctl stop database -d racdb

3- On any node startup one instance in mount state and enable archivelog mode:

   sqlplus "/ as sysdba"
   startup mount;
   alter database archivelog;


4- Shutdown the previous running node:
   sqlplus "/ as sysdba"
   shutdown immediate;

5- Start all instance back:

     srvctl start database -d racdb

To check the mode:

   sqlplus "/ as sysdba"
   archive log list;

or

 select log_mode from v$database;

1 comment:

  1. U forgot to change parameter cluster_database to true before step 4.

    SQL> alter system set cluster_database=true scope=spfile sid='racdb1';

    Thanks
    Nikhil Sharma

    ReplyDelete

Number of Visitors