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_at_xerox.com> 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_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
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 21 2005 - 15:05:53 CDT
