Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.