创建控制文件 ORA-01192 解决方法

在重建控制文件时

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/ischedule.259.864426229\'
    
18.  18 CHARACTER SET AL32UTF8
    
19.  19 ;

收到如下错误

1. CREATE CONTROLFILE REUSE DATABASE \"HOST\" NORESETLOGS FORCE LOGGING ARCHIVELOG
   
2. *
   
3. ERROR at line 1:
   
4. ORA-01503: CREATE CONTROLFILE failed
   
5. ORA-01192: must have at least one enabled thread

 解决方法

1. SQL> CREATE CONTROLFILE SET DATABASE \"HOST\" RESETLOGS FORCE LOGGING ARCHIVELOG

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

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