Restore Oracle without Catalog and without Control Files

[Benoît]

Hi,

Is it possible to restore Oracle DB without Catalog and without Control Files.

Actualy we have only Online backups made with Data Protector and Oracle Integration Agent and Business Copy Agent for SureStore VA.
No Cold backup of raw_devices.
Only Online Full/Incremental made with RMAN.

Is it possible to restore a full Online Backup with RMAN and backups we have ?

Thanks

[renarios]

Hi Benoit,

Apology for the late reaction, but I had to recover from an eye surgery.
It should be possible to recover a database using RMAN.
Set your environment issuing the commandâ . oraenvâ
Connect to the target without a catalog using the command "rman nocatalog"
In RMAN connect to the target, i.e. "connect target /"
Now you see the following:
connected to target database: ORCL(DBID=3885305290)
using target database controlfile instead of recovery catalog
If you donâ t know the DBID, list the backup directory. With the files you can find out your DBID:
orcl_c-3885305290-20050623-00 ï The number after the â c-â (3885305290) is your DBID.
Connect to the target without a catalog using the command "rman nocatalog"
In RMAN connect to the target, i.e. "connect target /"
set DBID = 3885305290;
startup nomount;
restore spfile from autobackup;
restore controlfile from autobackup;
alter database mount;
recover database; (If you are not in archivelog mode try recover database noredo;)
alter database open resetlogs;

Hope that helps a bit.

[Volker Borowski]

Hi,

I think not.
And beside either a catalog or the controlfile you would need the archivelogs as well.
If you use the controlfile to register your backups, even your current controlfile might be of help, if the backup you like to restore is still registered in there. So you might not need the one from the time of your backup if you are lucky.

Volker