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
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
This comment has been removed by a blog administrator.
ReplyDelete