What is the role of CLUSTER_DATABASE when starting and closing and changing the archiving mode under rac
This article shows you what the role of CLUSTER_DATABASE is when starting and shutting down and changing the archiving mode under rac. The content is concise and easy to understand, and it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.
When the archiving is closed normally in RAC mode, an error is reported: ORA-01126: database must be mounted EXCLUSIVE, which needs to be handled with the following steps:
Turn off automatic archiving
Alter system set log_archive_start=false scope=spfile
See parameters
SQL > show parameter cluster_database
NAME TYPE VALUE
-
Cluster_database boolean TRUE
Cluster_database_instances integer 2
Execute on one host:
Alter system set cluster_database=false scope=spfile sid='*'
Execute on both hosts:
Shutdown immediate
Execute on one host:
Startup mount (you must wait for two machines to finish shutdown at the same time)
Alter database noarchivelog
Alter database open
Alter system set cluster_database=true scope=spfile sid='*'
Shutdown immediate
Execute on both hosts:
Startup
At this point, you can close the archive after modification. The method of enabling archiving is similar.
-
SQLPLUS > ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE
SQLPLUS > shutdown immediate
SQLPLUS > startup mount exclusive
SQLPLUS > alter database noarchivelog
SQLPLUS > ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE
SQLPLUS > shutdown immediate
SQLPLUS > STARTUP
Yes, you can.
SQLPLUS > ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE
SQLPLUS > shutdown immediate
SQLPLUS > startup mount
SQLPLUS > alter database noarchivelog
SQLPLUS > ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE
SQLPLUS > shutdown immediate
SQLPLUS > STARTUP
It's okay, too.
The above is the role of CLUSTER_DATABASE when starting and shutting down and changing the archiving mode under rac. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.
