ORA 600[kcfccfl_1] or ORA 600[kccccfl_1] ,ORA02236 create controlfile解决方法

在手动创建控制文件时,抛出下面错误

  1. SQL> CREATE CONTROLFILE REUSE DATABASE \"HOST\" NORESETLOGS FORCE LOGGING ARCHIVELOG
  2.   2 MAXLOGFILES 192
  3.   3 MAXLOGMEMBERS 3
  4.   4 MAXDATAFILES 1024
  5.   5 MAXINSTANCES 32
  6.   6 MAXLOGHISTORY 292
  7.   7 LOGFILE
  8.   8 GROUP 1 \'+DATA/dbjx/onlinelog/group_1.373.871427395\' SIZE 50M BLOCKSIZE 512,
  9.   9 GROUP 2 \'+DATA/dbjx/onlinelog/group_2.265.864426495\' SIZE 50M BLOCKSIZE 512,
  10.  10 GROUP 3 \'+DATA/dbjx/onlinelog/group_3.264.864426511\' SIZE 50M BLOCKSIZE 512,
  11.  11 GROUP 4 \'+DATA/dbjx/onlinelog/group_4.276.864426525\' SIZE 50M BLOCKSIZE 512,
  12.  12 DATAFILE
  13.  13 \'+DATA/dbjx/datafile/system.281.864425653\',
  14.  14 \'+DATA/dbjx/datafile/sysaux.282.864425855\',
  15.  15 \'+DATA/dbjx/datafile/undotbs1.256.864426041\',
  16.  16 \'+DATA/dbjx/datafile/users.258.864426167\',
  17.  17 \'+DATA/dbjx/datafile/schedule.259.864426229\'
  18.  18 CHARACTER SET AL32UTF8
  19.  19 ; 
 收到如下错误

  1. CREATE CONTROLFILE REUSE DATABASE \"HOST\" NORESETLOGS FORCE LOGGING ARCHIVELOG
  2. *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-00600: internal error code, arguments: [kcfccfl_1], [], [], [], [], [], [],[]    
 解决方法

  1. GROUP 4 \\\'+DATA/dbjx/onlinelog/group_4.276.864426525\\\' SIZE 50M BLOCKSIZE 512, <--将此处的逗号去掉即可
   
补充:

For 10.2 Database, you receive:

  1. CREATE CONTROLFILE REUSE DATABASE \"R10205\" NORESETLOGS NOARCHIVELOG
  2. *
  3. ERROR at line 1:
  4. ORA-01503: CREATE CONTROLFILE failed
  5. ORA-00600: internal error code, arguments: [kcfccfl_1], [], [], [], [], [], [],[]
For 11.1 to 11.2.0.2 Databases, you receive:

  1. CREATE CONTROLFILE REUSE DATABASE \"R11201\" NORESETLOGS NOARCHIVELOG
  2. *
  3. ERROR at line 1:
  4. ORA-01503: CREATE CONTROLFILE failed
  5. ORA-00600: internal error code, arguments: [kccccfl_1], [], [], [], [], [], [],[], [], [], [], []
For 11.2.0.3 Database, you receive:

  1. DATAFILE
  2. *
  3. ERROR at line 12:
  4. ORA-02236: invalid file name

请使用浏览器的分享功能分享到微信等