Re: URGENT RECOVERY

On Oct 31, 2007 10:02 AM, David Barbour <david.barbour1_at_gmail.com> 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_at_yahoo.com> 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
--
http://www.freelists.org/webpage/oracle-l