On Oct 31, 2007 10:02 AM, David Barbour <david.barbour1@xxxxxxxxx> wrote: > Did you get this solved? What version of Oracle are you on? What is the > platform? How are you performing the restore - from offline cold backup, > online hot backup, RMAN or "traditional" methodolgy? > > > > On 10/31/07, Paula Stankus <paulastankus@xxxxxxxxx> wrote: > > > > 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 > > Greetings Have you checked in Metalink, vaguely remember this as a BUG in Oracle 8174 and there is a Patch for this. Remember applying this Patch and recovery went through fine. -- Regards & Thanks BN -- //www.freelists.org/webpage/oracle-l