在RAC环境中recreate controlfile 提示ORA-01503和ORA-12720 错误

在RAC环境中Recreate controlfile时，提示以下提示ORA-01503和ORA-12720 错误错误信息，如下所示

SQL> STARTUP NOMOUNT
ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed Size   2257880 bytes
Variable Size 570428456 bytes
Database Buffers 260046848 bytes
Redo Buffers   6549504 bytes

SQL>CREATE CONTROLFILE REUSE DATABASE "MHXY" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 192
    MAXLOGMEMBERS 3
    MAXDATAFILES 1024
    MAXINSTANCES 32
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '+DATA/mhxy/onlinelog/group_1.261.922980083',
    '+ARCH/mhxy/onlinelog/group_1.258.922980089'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 2 (
    '+DATA/mhxy/onlinelog/group_2.262.922980095',
    '+ARCH/mhxy/onlinelog/group_2.259.922980101'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 3 (
    '+DATA/mhxy/onlinelog/group_3.266.922981121',
    '+ARCH/mhxy/onlinelog/group_3.260.922981129'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 4 (
    '+DATA/mhxy/onlinelog/group_4.267.922981137',
    '+ARCH/mhxy/onlinelog/group_4.261.922981145'
  ) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '+DATA/mhxy/datafile/system.256.922979845',
  '+DATA/mhxy/datafile/sysaux.257.922979845',
  '+DATA/mhxy/datafile/undotbs1.258.922979845',
  '+DATA/mhxy/datafile/users.259.922979847',
  '+DATA/mhxy/datafile/example.264.922980153',
  '+DATA/mhxy/datafile/undotbs2.265.922980651',
  '+DATA/mhxy/datafile/fy_rst_data.dat',
  '+DATA/mhxy/datafile/t1.279.937174643',
  '+DATA/mhxy/datafile/t2.274.937174587'
CHARACTER SET AL32UTF8;


CREATE CONTROLFILE REUSE DATABASE "MHXY" NORESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode

在时候需要把RAC环境设置未EXCLUSIVE模式，才可以执行重建控制文件操作

SQL> alter system set cluster_database=false scope=spfile sid='*';

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup nomount;

再次执行Recreate操作，执行成功

SQL>CREATE CONTROLFILE REUSE DATABASE "MHXY" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 192
    MAXLOGMEMBERS 3
    MAXDATAFILES 1024
    MAXINSTANCES 32
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '+DATA/mhxy/onlinelog/group_1.261.922980083',
    '+ARCH/mhxy/onlinelog/group_1.258.922980089'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 2 (
    '+DATA/mhxy/onlinelog/group_2.262.922980095',
    '+ARCH/mhxy/onlinelog/group_2.259.922980101'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 3 (
    '+DATA/mhxy/onlinelog/group_3.266.922981121',
    '+ARCH/mhxy/onlinelog/group_3.260.922981129'
  ) SIZE 50M BLOCKSIZE 512,
  GROUP 4 (
    '+DATA/mhxy/onlinelog/group_4.267.922981137',
    '+ARCH/mhxy/onlinelog/group_4.261.922981145'
  ) SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '+DATA/mhxy/datafile/system.256.922979845',
  '+DATA/mhxy/datafile/sysaux.257.922979845',
  '+DATA/mhxy/datafile/undotbs1.258.922979845',
  '+DATA/mhxy/datafile/users.259.922979847',
  '+DATA/mhxy/datafile/example.264.922980153',
  '+DATA/mhxy/datafile/undotbs2.265.922980651',
  '+DATA/mhxy/datafile/fy_rst_data.dat',
  '+DATA/mhxy/datafile/t1.279.937174643',
  '+DATA/mhxy/datafile/t2.274.937174587'
CHARACTER SET AL32UTF8;

Control file created.

数据恢复应用归档日志文件，然后OPEN数据库

SQL> RECOVER DATABASE
Media recovery complete.
SQL> ALTER DATABASE OPEN;

Database altered.

SQL>ALTER TABLESPACE TEMP ADD TEMPFILE '+DATA/mhxy/tempfile/temp.263.922980127' REUSE;

最后，恢复参数CLSUTER_DATABASE=TRUE，重启所有数据库节点

SQL> alter system set cluster_database=true scope=spfile sid='*';

SQL> startup force

ORACLE instance started.

Total System Global Area  839282688 bytes
Fixed Size   2257880 bytes
Variable Size 570428456 bytes
Database Buffers 260046848 bytes
Redo Buffers   6549504 bytes
Database mounted.
Database opened.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27039319/viewspace-2134460/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27039319/viewspace-2134460/