Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ho to recover database from rman backup without catalog

592815Dec 14 2008 — edited May 25 2009
Hi Experts,

I am working on DB with new company policy/procedure. Each day, it use rman to full back database without catalog.

The log syntax as
rmam target='sys/sysdba as sysdba' nocatalog

I got message that log into rman system..... using control file instead of catalog.
Follow up run a script to crosscheck database and then

delete obsolet
configure chanel device type disk format 'F:\oraclebackup\rman\%U';
backup as cpmpressed backupset tag=sysdate database plus archivelog;

My question: We make a full backup without catalog and compressed in rman.
How to make a recover if we need to recover DB?

Any expert can show me some command in detail?
We use oracle10GR2 in window 2003.

Thanks,
Jim
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2009
Added on Dec 14 2008
12 comments
2,638 views