URGENT RECOVERY
- From: Paula Stankus <paulastankus@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 30 Oct 2007 23:00:01 -0700 (PDT)
Guys,
Trying to restore and recover and when I get to a specific archive file the
database produces ora-600 errors and the database crashes.
When I go to an earlier archive then I get ora-01547, ora-01245.
I am copying backup files and starting again.
I am wondering if I go back even farther if it will work but then I will have
lost a few hours on the database.
Would going to the point where I get the ora-01547, ora-1245 and then doing a
offline drop on those datafiles work? Then I could recreate those datafiles,
tablespaces and import those users/schemas.
How do I know for sure how far I can go with the archives and get my database
back up and running??
It looks like files where corrupted or overwritten with a previous file.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Other related posts:
