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

  • apporacle

    2015-03-11 16:39:24
  • Oracle
  • 原创
在重建控制文件时

  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

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