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@xxxxxxxxx] 
Sent: Thursday, July 21, 2005 3:39 PM
To: Hameed, Amir
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Manjula Krishnan
> Sent: Thursday, July 21, 2005 3:08 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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

Other related posts: