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!

Clarifications on RMAN using catalog database and no catalog (controlfile)

myluismSep 18 2015 — edited Sep 18 2015

Hi all.

I´d like some clarifications on RMAN topics regarding the use of RMAN with or without a recovery catalog (Database / Schema):

1) Will controfile of the target database always store ALL changes performed on RMAN ?. For example, configuring RMAN persistent changes like retention policy, controfile autobackup, backup optimization on and so forth, will these always be recorded on the target database controlfile, even if one connects to RMAN with recovery catalog?

2) What happens if one stops using the recovery catalog? I mean, if you are not using stored scripts and have them fired through OS jobs or even EM Database Control Jobs, can one continue using then and not connect anymore to the recovery catalog?. Will this be an issue? Will my target database stop?

I will be inheriting a few databases to administer and they are connecting to a recovery catalog Database / Schema, that is good, but i want to implement my own backup and restore policies / procedures in a two step process: (1) Have each database RMAN configuration on controlfile, (2) Later considering the use of recovery catalog to centralized several databases and retain more records of backup and restore.

Thanks in advance!!!!

This post has been answered by top.gun on Sep 18 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2015
Added on Sep 18 2015
4 comments
1,688 views