RE: Recovery Scenario

You can use command:
Recover database using backup controlfile until cancel ; And then cancel recovery at some point in time before the crash.

Did you loose all files after the crash ?

-----Original Message-----
From: Manjula Krishnan [mailto:oradba.la_at_gmail.com] Sent: Thursday, July 21, 2005 3:39 PM
To: Hameed, Amir
Cc: oracle-l_at_freelists.org
Subject: Re: Recovery Scenario

So, I just restore the datafiles (from day1), backup control file from day 1 and then issue recover database until cancel, and supply archivelogs until time xx:xx and I can recover completely?

On 7/21/05, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> Yes you can. If your database crashed due to some corruption reasons
> then you may want to apply logs just before the time when the crashed
> took place.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Manjula Krishnan
> Sent: Thursday, July 21, 2005 3:08 PM
> To: oracle-l_at_freelists.org
> Subject: Recovery Scenario
>
> Say I have the following scenario.
>
> Day 1: Hot Backup - all files backup successfully
> Day 2: Hot Backup - one file does not back up
> Day 3: Database crashes
>
> Using Day 1 backup, can I restore to current time assuming I have all
> archive logs needed?
>
> Thanks,
>
> Manjula
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l