recreation of control files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: recreation of control files

  1. #1
    Join Date
    Jan 2010
    Posts
    1

    recreation of control files

    My Oracle server went down,
    I tried to copy all the database folder but some files can not copied (media error),
    I repaired the disk then finally copied all folder files successfully,
    installed new oracle database server,
    created database with the same name,
    copied the folder instead of the new one,
    tried to start it up but there is an error Ora-00209,
    it runs on nemounts only
    that error indicates contril files mismatch with the data files headers I think,
    I tried to create new control files using the following syntax;

    CREATE CONTROLFILE REUSE DATABASE "MONTJ" NORESETLOGS
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 14
    MAXINSTANCES 1
    MAXLOGHISTORY 226
    LOGFILE
    GROUP 1 'F:\ORACLE\ORADATA\MONTJ\REDO01.LOG' SIZE 100M,
    GROUP 2 'F:\ORACLE\ORADATA\MONTJ\\REDO02.LOG' SIZE 100M,
    GROUP 3 'F:\ORACLE\ORADATA\MONTJ\\REDO03.LOG' SIZE 100M
    DATAFILE
    'F:\ORACLE\ORADATA\MONTJ\ INDX01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ TOOLS01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ SYSTEM01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ UNDOTBS01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ EXAMPLE01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ USERS01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ OEM_REPOSITORY.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ CWMLITE01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ DRSYS01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ ODM01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ XDB01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ \TEM01.DBF'
    CHARACTER SET AR8MSWIN1256
    ;

    But it's giving this error;


    CREATE CONTROLFILE REUSE DATABASE "MONTJ" NORESETLOGS
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file 'F:\ORACLE\ORADATA\MONTJ\ INDX01.DBF'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.

    any one can help please

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Do you have a real backup?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Oct 2008
    Posts
    69
    Quote Originally Posted by WOLEMY View Post
    My Oracle server went down,


    CREATE CONTROLFILE REUSE DATABASE "MONTJ" NORESETLOGS
    MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 14
    MAXINSTANCES 1
    MAXLOGHISTORY 226
    LOGFILE
    GROUP 1 'F:\ORACLE\ORADATA\MONTJ\REDO01.LOG' SIZE 100M,
    GROUP 2 'F:\ORACLE\ORADATA\MONTJ\\REDO02.LOG' SIZE 100M,
    GROUP 3 'F:\ORACLE\ORADATA\MONTJ\\REDO03.LOG' SIZE 100M
    DATAFILE
    'F:\ORACLE\ORADATA\MONTJ\ INDX01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ TOOLS01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ SYSTEM01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ UNDOTBS01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ EXAMPLE01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ USERS01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ OEM_REPOSITORY.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ CWMLITE01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ DRSYS01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ ODM01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ XDB01.DBF',
    'F:\ORACLE\ORADATA\MONTJ\ \TEM01.DBF'
    CHARACTER SET AR8MSWIN1256
    ;

    But it's giving this error;


    CREATE CONTROLFILE REUSE DATABASE "MONTJ" NORESETLOGS
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file 'F:\ORACLE\ORADATA\MONTJ\ INDX01.DBF'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.

    any one can help please

    You appear to have a space at the beginning of the filename. I have highlighted the first few but all appear to have these spaces.
    Take out the spaces. Oracle cannot find the files because their names don't begin with a blank space.

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