RE: Restore Controlfile from Autobackup Question

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Wed, 5 Mar 2008 10:19:41 +0100
Message-ID: <AF9ECF804B2F294BB43BC5063302658F0A5B524351@ws03-exch07.iconos.be>


Sam,

Oracle keeps all backup information in the controlfiles, even if you have a recovery catalog. So yes, oracle would use your incremental backups.

Wat you would need to do is to restore the controlfile from autobackup, mount that controlfile and then follow the normal restore/recovery steps (without recovery catalog).

set DBID=<your dbid>
set controlfile autobackup format for device type disk to '...%F' restore controlfile from autobackup;

Regards,

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 05 2008 - 03:19:41 CST

Original text of this message