Skip to Main Content

Oracle Database Discussions

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!

Using target database control file instead of recovery catalog in 11g

Dude!Jun 21 2010 — edited Jun 21 2010
Hello,

I understand there are limitations that apply when using the target database controlfile as the source for RMAN records. I read that RMAN records, when using the target controlfile, get overwriten according to the retention policy or when the controlfile cannot expand due filesystem limits.

I have a few questions and cannot find a clear answer. Perhaps somebody here can help.

The RMAN settings and backup records are always stored in the target database control file and a "resync catalog" or successful backup is actually a one-way copy merge from the database target control file to the RMAN catalog. Correct?

The default retention policy is set to REDUNDANCY 1. I assume this means I will always be able to perform a full database restore from the last backup using the control file, even if I do not connect to or loose the RMAN catalog. Correct?

I noticed that the CONTROL_FILE_RECORD_KEEP_TIME, default 7 days, sets the MINIMUM number of days before a reusable record in the control file can be reused. So I understand this setting has NO affect when setting it lower than the current retention policy. Correct?

Provided the above is correct, I figure there is actually no difference in terms of database recoverability in regard to the configured retention policy between using the RMAN catalog or loosing the RMAN catalog. In particular after a "delete obsolete" or unless I need a "backup ... keep forever". Oracle mentions long-term storage as a key advantage using the RMAN catalog instead of the target control file, but it seems to me, it's rather a questions of reliability. Correct?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2010
Added on Jun 21 2010
2 comments
8,906 views