重建控制文件报错 ORA-01503 ORA-01192

1. 错误信息

ORA-01503: CREATE CONTROLFILE failed
ORA-01192: must have at least one enabled thread

 

2. 重建脚本

CREATE CONTROLFILE REUSE DATABASE test NORESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/oradata/onlinelog/group_1.373.871427395' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/oradata/onlinelog/group_2.265.864426495' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/oradata/onlinelog/group_3.264.864426511' SIZE 50M BLOCKSIZE 512,
GROUP 4 '/oradata/onlinelog/group_4.276.864426525' SIZE 50M BLOCKSIZE 512
DATAFILE
'/oradata/datafile/system.281.864425653',
'/oradata/datafile/sysaux.282.864425855',
'/oradata/datafile/undotbs1.256.864426041',
'/oradata/datafile/users.258.864426167',
'/oradata/datafile/ischedule.259.864426229'
CHARACTER SET ZHS16GBK
;

3. 处理方法

将 NORESETLOGS 改为 RESETLOGS

转载于:https://www.cnblogs.com/halberd-lee/p/8658229.html