Sunday, 23 October 2016

How to put RAC database in archive log.

1) Login to any rac node and export oracle sid.

export ORACLE_SID=test1
sqlplus / as sysdba

2) Check archive log is enabled or not by using below query.

select name ,created ,open_mode ,log_mode from v$database;
or
archive log list;

3) Disable cluster instance parameter by setting cluster database to FALSE from the current instance.

alter system set cluster_database=false scope=spfile

4) Exit from sqlplus prompt and fire srvctl commands to stop all instances accessing cluster database

srvctl stop database -d test

5) Again login to local instance using sqlplus and mount database.

sqlplus / as sysdba
startup mount;

6) Enable archive log using below command.

alter database archivelog;

7) Re-enable support for clustering by setting instance parameter cluster_database to TRUE

alter system set cluster_database=true scope=spfile

8) shutdown local instance

shut immediate;

9) Bring all instance back up using srvctl

srvctl start database -d test

10) Login to local instance and check if archive log is enabled or not

sqlplus / as sysdba
archive log list;
or
select name ,created ,open_mode ,log_mode from v$database;

No comments:

Post a Comment