Re: Restoring from an old cold backup

there is on caveat:

if you restore a cold, consistent backup set that includes the current controlfile, instance recovery will automatically be peformed and since all datafiles are consistent with the current controlfile, no recovery will be required and the database will be opened - before you have a chance to apply any archived redo logs post-cold backup.

Instead you will want to manually startup the instance into a mount state and recover database using backup controlfile until cancel. The after you have applied the archived redo logs, a statement of:

alter database open resetlogs

will be needed to open the database.

hth.

-bdbafh Received on Sun Jun 26 2005 - 12:23:39 CDT