RE: Restore Controlfile from Autobackup Question

From: D'Hooge Freek <>
Date: Wed, 5 Mar 2008 10:19:41 +0100
Message-ID: <>


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;


Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

Received on Wed Mar 05 2008 - 03:19:41 CST

Original text of this message