URGENT RECOVERY 2007-11-04 - By BN
Back
On Oct 31, 2007 10:02 AM, David Barbour <david.barbour1@(protected)> 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@(protected)> wrote:
> >
> > Guys,
> >
> > Trying to restore and recover and when I get to a specific archive file
> the database produces ora-600 (See http://ora-600.ora-code.com) errors and the database crashes.
> >
> > When I go to an earlier archive then I get ora-01547 (See http://ora-01547.ora-code.com), ora-01245 (See http://ora-01245.ora-code.com).
> >
> > 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 (See http://ora-01547.ora-code.com), ora-1245 (See http://ora-1245.ora-code.com) 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
|
|
