Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: URGENT RECOVERY
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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 31 2007 - 10:02:10 CDT