SQL> CREATE CONTROLFILE REUSE DATABASE "SSAERP" NORESETLOGS FORCE
2 logging archivelog
3 MAXLOGFILES 16
4 MAXLOGMEMBERS 3
5 MAXDATAFILES 100
6 MAXINSTANCES 8
7 MAXLOGHISTORY 31664
8 LOGFILE
9 GROUP 4 '/ora/ora_dat/ssaerp/redo04.log' SIZE 50M BLOCKSIZE 512,
10 GROUP 5 '/ora/ora_dat/ssaerp/redo05.log' SIZE 50M BLOCKSIZE 512,
11 GROUP 6 '/ora/ora_dat/ssaerp/redo06.log' SIZE 50M BLOCKSIZE 512
12 datafile
13 '/ora/ora_dat/ssaerp/system01.dbf',
14 '/ora/ora_dat/ssaerp/undotbs01.dbf',
15 '/ora/ora_dat/ssaerp/sysaux01.dbf',
16 '/ora/ora_dat/ssaerp/users01.dbf',
17 '/ora/ora_dat/ssaerp/system02.dbf',
18 '/ora/ora_dat/ssaerp/xdb_SSAERP01.dbf',
19 '/ora/ora_idx/ssaerp/xdb_SSAERP01.dbf',
20 '/ora/ora_dat/ssaerp/xdb_SSAERP02.dbf',
21 '/ora/ora_dat/ssaerp/xdb_SSAERP03.dbf',
22 '/ora/ora_dat/ssaerp/xdb_SSAERP04.dbf',
23 '/ora/ora_dat/ssaerp/xdb_SSAERP05.dbf',
24 '/ora/ora_dat/ssaerp/xdb_SSAERP06.dbf',
25 '/ora/ora_dat/ssaerp/xdb_SSAERP07.dbf',
26 '/ora/ora_dat/ssaerp/xdb_SSAERP08.dbf',
27 '/ora/ora_dat/ssaerp/xdb_SSAERP09.dbf',
28 '/ora/ora_dat/ssaerp/xdb_SSAERP10.dbf',
.......
.......
56 CHARACTER SET WE8ISO8859P1;
CREATE CONTROLFILE REUSE DATABASE "SSAERP" NORESETLOGS FORCE
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01192: must have at least one enabled thread
Solution:
CREATE CONTROLFILE SET DATABASE "PCARD" RESETLOGS FORCE LOGGING NOARCHIVELOG
