Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Restore Oracle without Catalog and without Control Files

Benoît
Regular Advisor

Restore Oracle without Catalog and without Control Files

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
2 REPLIES
renarios
Trusted Contributor

Re: Restore Oracle without Catalog and without Control Files

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.
Nothing is more successfull as failure
Volker Borowski
Honored Contributor

Re: Restore Oracle without Catalog and without Control Files

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