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

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

转载于:http://blog.itpub.net/28697282/viewspace-1456254/