|
[oracle-l]
||
[Date Prev]
[03-2008 Date Index]
[Date Next]
||
[Thread Prev]
[03-2008 Thread Index]
[Thread Next]
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
________________________________________
--
http://www.freelists.org/webpage/oracle-l
|
|
