Re: Recovery Scenario

  • From: <rjsearle@xxxxxxxxx>
  • To: Amir.Hameed@xxxxxxxxx
  • Date: Fri, 22 Jul 2005 06:03:34 +1000

We just did this, and you must be careful. We did a restore until cancel as 
we lost every disk in the pack, however this resulted in an incomplete 
recovery. we therefore had to open the database resetlogs. this is a oneway 
step. when you do this you then must perform a reset database in RMAN. also 
previous backups become useless so take 2 backups of the DB at this point 
for safe keeping.
 Russell
 PS what about your online redos? Are they OK? How did the crash happen and 
what is the extent of the damage to the DB?

 On 7/22/05, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote: 
> 
> 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: