Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: URGENT RECOVERY

Re: URGENT RECOVERY

From: David Barbour <david.barbour1_at_gmail.com>
Date: Wed, 31 Oct 2007 11:02:10 -0400
Message-ID: <69eafc3f0710310802r4ce641ddr677b456c7eac4c05@mail.gmail.com>


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-l
Received on Wed Oct 31 2007 - 10:02:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US