重建过程出错:
ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode
解决办法是停掉一个实例orcl2,然后在orcl1上执行:
sqlplus /nolog
conn sys as sysdba
alter system set cluster_database=FALSE scope=spfile sid='*';
shutdown immediate
可以继续执行重建控制文件的脚本了。
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024