URGENT RECOVERY

From: Paula Stankus <paulastankus_at_yahoo.com>
Date: Tue, 30 Oct 2007 23:00:01 -0700 (PDT)
Message-ID: <882796.80910.qm@web33213.mail.mud.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 31 2007 - 01:00:01 CDT