DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: recovery problem

  1. #1
    Join Date
    Mar 2003
    Location
    Sofia, Bulgaria
    Posts
    64

    recovery problem

    I have a test base running oracle 9i on linuix. I tried to make backup tru backup manager. Everything went ok the job was completed successfully. Then I tried recovey. This job also completed successfully. When I tried to open the database following error ocured ORA-01113: file 1 needs media recovery
    ORA-01110: data file: /u01../system01.dbf
    Any ideas ?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    what if you try to recover manually? if that still fails then your cold/hot backup is not a consistent/good backup, i.e bad

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    arokh,
    I would suggest not to use that GUI if you want to know what lies beneath the GUI. Try recovering it manually, refer to the docs and if you still have problem www.dbasupport.com
    Last edited by SANJAY_G; 05-22-2003 at 04:48 AM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Mar 2003
    Location
    Sofia, Bulgaria
    Posts
    64
    when i looked at the script generated by the wizart i saw that the recovery performs only restore of the physical files. I had to manualy "recover database" to synchronise the file and now i am able to open the database

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by arokh
    when i looked at the script generated by the wizart i saw that the recovery performs only restore of the physical files. I had to manualy "recover database" to synchronise the file and now i am able to open the database
    Great!
    Thats the advantage of not using GUIs
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    do yourself a favor and stay away from the gui, you will build your skillset faster and be a better dba for it.
    Last edited by stmontgo; 05-22-2003 at 10:20 PM.
    I'm stmontgo and I approve of this message

  7. #7
    Join Date
    Mar 2003
    Location
    Sofia, Bulgaria
    Posts
    64

    Talking

    I will follow this advice

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