-
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
Oracle freak & about-to-be DB2 freak
Singapore
-
ORA-01192 must have at least one enabled thread
Cause: At least two redo log files from at least one thread must be specified in the CREATE CONTROLFILE command line.
Action: Find the missing redo log files and retry the command with the newly found redo log files included in the command line.
It seems there were some error happened when os created the redo logfiles.
Why not to try use Replication, Standby DB, or Cold Backup (assuming with same directory structure)?
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
CONTROLFILE
There appears to be a problem in Redolog file creation. Are the redolog files which u used for creation r correct or not. Once check up all redolog files
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|