Cannot create controlfile
Hi guys,
In my shop I have to move the prod database to a new instance everyday so that people can generate report from the new one instead of pestering the prod database.
I have been using the create controlfile script I got from backup to trace and so far it was working well until yesterday night. I got an error like this when I created the controlfile using the script I modified to cater to the files location changes.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORS" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1630
LOGFILE
GROUP 1 ('D:\ORACLE\ORADATA\ORS\REDO03.LOG','D:\ORACLE\ORADATA\ORS\REDO13.LOG')
GROUP 2 ('D:\ORACLE\ORADATA\ORS\REDO02.LOG','D:\ORACLE\ORADATA\ORS\REDO12.LOG')
GROUP 3 ('D:\ORACLE\ORADATA\ORS\REDO01.LOG','D:\ORACLE\ORADATA\ORS\REDO11.LOG')
DATAFILE
'D:\ORACLE\ORADATA\ORS\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\ORS\RBS01.DBF',
'D:\ORACLE\ORADATA\ORS\USERS01.DBF',
'D:\ORACLE\ORADATA\ORS\TEMP01.DBF',
'D:\ORACLE\ORADATA\ORS\TOOLS01.DBF',
'D:\ORACLE\ORADATA\ORS\INDX01.DBF',
'D:\ORACLE\ORADATA\ORS\CONS_GRO_INDX01.DBF',
'D:\ORACLE\ORADATA\ORS\CONS_GRO_TAB01.DBF',
'D:\ORACLE\ORADATA\ORS\DEP_INDX01.DBF',
'D:\ORACLE\ORADATA\ORS\DEP_TAB01.DBF',
'D:\ORACLE\ORADATA\ORS\DIAG_INDX01.DBF',
'D:\ORACLE\ORADATA\ORS\DIAG_TAB01.DBF',
'D:\ORACLE\ORADATA\ORS\LOB_DATA01.DBF',
'D:\ORACLE\ORADATA\ORS\RAP_GRO_INDX01.DBF',
'D:\ORACLE\ORADATA\ORS\RAP_GRO_TAB01.DBF',
'D:\ORACLE\ORADATA\ORS\SYS_MET_INDX01.DBF',
'D:\ORACLE\ORADATA\ORS\SYS_MET_TAB01.DBF',
'D:\ORACLE\ORADATA\ORS\TEMP_INDX01.DBF',
'D:\ORACLE\ORADATA\ORS\TEMP_TAB01.DBF',
'D:\ORACLE\ORADATA\ORS\VER_INDX01.DBF',
'D:\ORACLE\ORADATA\ORS\VER_TAB01.DBF'
CHARACTER SET WE8ISO8859P1
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add.
then I got the error like this after I run the script in nomount state.
ORA-1503 - Create Controlfile failed
ORA-1192 - Must have at least one enabled thread
Anybody familiar with this phenomena?
Thanks in advance.
Ric