-
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 ?
-
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
-
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"
-
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
-
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"
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|