-
SQL> CREATE CONTROLFILE REUSE DATABASE \"HOST\" NORESETLOGS FORCE LOGGING ARCHIVELOG
-
2 MAXLOGFILES 192
-
3 MAXLOGMEMBERS 3
-
4 MAXDATAFILES 1024
-
5 MAXINSTANCES 32
-
6 MAXLOGHISTORY 292
-
7 LOGFILE
-
8 GROUP 1 \'+DATA/dbjx/onlinelog/group_1.373.871427395\' SIZE 50M BLOCKSIZE 512,
-
9 GROUP 2 \'+DATA/dbjx/onlinelog/group_2.265.864426495\' SIZE 50M BLOCKSIZE 512,
-
10 GROUP 3 \'+DATA/dbjx/onlinelog/group_3.264.864426511\' SIZE 50M BLOCKSIZE 512,
-
11 GROUP 4 \'+DATA/dbjx/onlinelog/group_4.276.864426525\' SIZE 50M BLOCKSIZE 512,
-
12 DATAFILE
-
13 \'+DATA/dbjx/datafile/system.281.864425653\',
-
14 \'+DATA/dbjx/datafile/sysaux.282.864425855\',
-
15 \'+DATA/dbjx/datafile/undotbs1.256.864426041\',
-
16 \'+DATA/dbjx/datafile/users.258.864426167\',
-
17 \'+DATA/dbjx/datafile/schedule.259.864426229\'
-
18 CHARACTER SET AL32UTF8
- 19 ;
-
CREATE CONTROLFILE REUSE DATABASE \"HOST\" NORESETLOGS FORCE LOGGING ARCHIVELOG
-
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00600: internal error code, arguments: [kcfccfl_1], [], [], [], [], [], [],[]
- GROUP 4 \\\'+DATA/dbjx/onlinelog/group_4.276.864426525\\\' SIZE 50M BLOCKSIZE 512, <--将此处的逗号去掉即可
补充:
For 10.2 Database, you receive:
-
CREATE CONTROLFILE REUSE DATABASE \"R10205\" NORESETLOGS NOARCHIVELOG
-
*
-
ERROR at line 1:
-
ORA-01503: CREATE CONTROLFILE failed
- ORA-00600: internal error code, arguments: [kcfccfl_1], [], [], [], [], [], [],[]
-
CREATE CONTROLFILE REUSE DATABASE \"R11201\" NORESETLOGS NOARCHIVELOG
-
*
-
ERROR at line 1:
-
ORA-01503: CREATE CONTROLFILE failed
- ORA-00600: internal error code, arguments: [kccccfl_1], [], [], [], [], [], [],[], [], [], [], []
-
DATAFILE
-
*
-
ERROR at line 12:
- ORA-02236: invalid file name