Re: Recovery on a New Machine

"Makbo" <makbo2_at_netscape.net> wrote in message news:3D8D1CB4.4000500_at_netscape.net...
> I have tried this before (best time to try it is in a test environment!!)
>
> It is not so straightforward (sometimes not possible) to roll forward
> archive redo logs made after a cold backup. Check the Oracle 8i
> documentation for "Restoring a Pre-RESETLOGS Backup: Scenario".
>
> Quote: "In this scenario, if you had opened the database after the
> Friday night backup and before opening the database with RESETLOGS, or,
> did not have a control file from after opening the database, you would
> not be able to use the Friday night backup to roll forward. You must
> have a backup after opening the database with the RESETLOGS option in
> order to be able to recover."

It is possible, but -as you indicate- only under certain circumstances, those being that the control files from before the resetlogs and after are still available, all archives from before and after the resetlogs are available, and you have nerves of steel.

The procedure is referred to in the Oracle doco as 'recovery through resetlogs'. It involves restoring the pre-resetlogs backup, recovering it to the change number associated with the resetlogs, switching the control files to the post-resetlogs ones, and continuing recovery.

You're right that its best to test this many times in a non-production environment first!!

Regards
HJR
>
> -Mark B.
>
> Nancy Wells wrote:
>
> > Candido Dessanti <termy_at_blunet.it> wrote in message
news:<3D8706E7.5010008_at_blunet.it>...
> >
> >>This is gonna be an incomplete recovery (you will miss all the
> >>transaction not recordered in archived logs)
> >>
> >>
> > I'm prepared for that.
> >
> >
> >>Install the same version of oracle on another machine then
> >>restore your cold backup and copy the archived redo logs
> >>you have on the target machine, possibly using the same
> >>path then;
> >>
> >>start the instance and mount it
> >>
> >>issue
> >>1)RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
> >>
> >>
> > I have a backup (cold) of the control file taken on Sunday, when all
> > the datafiles were backed up. Will that do. Is that what you mean by a
> > BACKUP CONTROLFILE. (I did do any BACKUP CONTROLFILE TO .....) Or
> > should the control file correspond to the time i'm planning to recover
> > to.
> >
> > I have a copy of the current control file, when the system crashed.
> > Can i use this?
> >
> >
> >>2)now oracle will generate the names of the archivedlogs it's missing on
> >>controlfile; apply all the archived logs you have and when finished type
> >>CANCEL
> >>
> >>
> > How will Oracle know what archive logs are required if i'm using
> > Sunday's control at which time the archives were not generated.
> >
> >
> >>now if successful you have to open the database resetting your redologs
> >>
> >>3)ALTER DATABASE OPEN RESETLOGS;
> >>
> >>4)check if everyhing is ok and take a full backup of your restored
database;
> >>
> >>If you have Redo Logs up to date you can try to do a complete recovery
> >>just change the 2 command with this
> >>ALTER DATABASE OPEN;
> >>If it doesnt work telling you to open with reset logs issue 2 command
> >>
> >>
> >>ciao
> >>
> >>ps: better if you take some time reading the documentation about
> >>backup/recovery in oracle's www site.
> >>
> >
> > Yes I should do that..... I have done quite a bit of documentation
> > reading but i'm not clear on this situation....
> >
> > Thanks in Advance.
> >
> > Best Regards,
> > N. Wells
> >
>
Received on Sat Sep 21 2002 - 20:42:20 CDT