Re: Recover question: ALTER DATABASE USING BACKUP CONTROLFILE

mokat67_at_hotmail.com wrote in message news:<3e99db18.3088651_at_news.hccnet.nl>...
> Supposing that I lost my online redo-log files and still in posession
> of controle and archive files
>
> I would like to know what is against the method:
>
> A) ALTER DATABASE USING BACKUP CONTROLFILE
>
> Instead of:
>
> B) Recover Database
>
> I know that method (A) is used when the latest control files are not
> available anymore. But if the current control files still exits is
> there a reason why not to choose for method (A) in combination with a
> cold backup restore action? What can be negative consequences if there
> are any?
>
> Thanks

I assume you mean RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE? Any - ho...

If you had a clean shutdown and lost your redo logs you could issue that statement to open the db and create new logs.

You could not simply issue Recover Database.

To open with new logs Oracle will only let you do so if it believes you are performing incomplete media recovery. To to do issue

RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE then when prompted for a log type CANCEL <this is faking media recovery>

then issue

alter database open restelogs

steve Received on Mon Apr 14 2003 - 07:37:30 CDT