10G R2 ORA-01194 - messed up system db - need help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: 10G R2 ORA-01194 - messed up system db - need help

  1. #1
    Join Date
    Aug 2008
    Location
    germany
    Posts
    1

    10G R2 ORA-01194 - messed up system db - need help

    hi!
    Recently I was told to become an Oracle DBA. Because I am an MCP for the MS SQL Server I have a strong background , but unfortunately this is far away from being convertible to the Oracle world.

    The last 2 days I spent to repair a damaged Oracle 10 instance. I had to recreate the control files, I had to rebuild the initInstancename.ora file, I have rebuilt the spfile.... after solving a dozen ORA messages I ended at this situation:

    The instance doesn't come up and tells me
    ORA-01194 file needs more recovery to become consistent.
    ORA-01110 'f:\path\system01.dbf'

    The only option left in the EM console was a database recovery, and I did it.
    The recovery failed because there were no information to recover.... so it is messed up and we don't have any backups.

    I have four dbf files with several tablespaces in int - Is there a way to copy this dbf file to a new installation and use them there?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    Basically the database is looking for redo information that it can't find.

    I have had luck pointing it to the online redo files. You can try the first example and see if it finds what it needs. You can also try the first example but specify each online redo file.

    Code:
    recover standby database using backup controlfile until cancel;
    AUTO
    Once you have tried the above you can try the basic command again but with the cancel keyword, which cancel's the recovery.

    It looks like you will need to open with reset logs. You may want to do a new backup of the database once you get everything running.

    Code:
    recover standby database using backup controlfile until cancel;
    CANCEL
    
    ALTER DATABASE OPEN RESETLOGS;
    Finally, I have worked with SQL Server 2000, and I can tell you that Oracle is a lot different, Especially dealing with recovery issues.

    Good Luck!!!
    this space intentionally left blank

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