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 >