Re: Recovery on a New Machine

From: Makbo <makbo2_at_netscape.net>
Date: Sun, 22 Sep 2002 01:28:21 GMT
Message-ID: <3D8D1CB4.4000500@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."

-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:28:21 CDT