RE: Recovery Scenario
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: "Manjula Krishnan" <oradba.la@xxxxxxxxx>
- Date: Thu, 21 Jul 2005 15:51:04 -0400
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
> --
> //www.freelists.org/webpage/oracle-l
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
