RE: Restore Controlfile from Autobackup Question

  • From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • To: "sbootsma@xxxxxxxxxxxxxx" <sbootsma@xxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 Mar 2008 10:19:41 +0100

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@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer


________________________________________
--
//www.freelists.org/webpage/oracle-l


Other related posts: