Enabling Archive log mode in RAC – Oracle 10g

In Database environment, set following database parameter as sysdba:

ALTER SYSTEM SET log_archive_format=’arch_%t_%s_%r.arc’ SCOPE=spfile;
ALTER SYSTEM SET log_archive_dest_1=’location=Path_of_archive_dir’ SCOPE=spfile;

Mount your database in exlusive mode by following ‘alter system’ command:
ALTER SYSTEM SET cluster_database=FALSE SCOPE=spfile;
Note:
Database is not accessible to any application or user, being in exclusive mode.

In Grid environment, stop the entire clustered database by following command as oracle user.
$ srvctl stop database -d SID
Note:
By above command, database will be shutdown.

SID: Global database name.

 

In Database environment, issue the following command to enable archive log mode:
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER SYSTEM SET cluster_database=TRUE SCOPE=spfile;
SHUTDOWN IMMEDIATE;

Note:
CLUSTER_DATABASE parameter has been changed to its orignal value.

In Grid environment, start the entire clustered database by following command as oracle user:
$ srvctl start database -d MYSID

In Database environment, Ensure changes by following SQL command:
SQL> archive log list;

 

By above method you will alter your RAC database to archive log mode.

************************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Leave a Reply