RAC模式下用常规方式关闭归档的时候,报错:ORA-01126: database must be mounted EXCLUSIVE,需要用一下步骤进行处理:
关闭自动归档
Alter system set log_archive_start=false scope=spfile
参看参数
SQL> show parameter cluster_database
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
在一台主机上执行:
alter system set cluster_database=false scope=spfile sid='*';
在两台主机上执行:
shutdown immediate
在一台主机上执行:
startup mount(必需要等2台机器同时shutdown完毕即可)
alter database noarchivelog;
alter database open;
alter system set cluster_database=true scope=spfile sid='*';
shutdown immediate;
在两台主机上执行:
Startup
此时修改完毕即可关闭归档,开启归档方法类似。
----------------------------------------
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
是可以的;
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
也是可以的啊