Cannot create controlfile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Cannot create controlfile

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    56

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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

  3. #3
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    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
  •  


Click Here to Expand Forum to Full Width