Monday, September 12, 2016

ENABLE ARCHIVE LOG - RAC

Enable archive

Step1 : disable rac cluster
alter system set cluster_database=false scope=spfile

Step :2 : Stop the databse
srvctl stop database -d prod

Step :3 : disable the archive logs
sqlplus "/as sysdba"

Step :4: Startup the database mount mode manually
startup mount

alter database archivelog;

Step :5 : Enable RAC cluster
alter system set cluster_database=true scope=spfile

Step :6 : check archive log disable
archive log list

it should as

Database log mode              No Archive Mode
Automatic archival             Disabled

Step :7 : Shutdown database Manually
Shutdown immediate

Step :8 : Start the database with crs command
srvctl start database -d prod

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete