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!

RMAN CONTROL_FILE_RECORD_KEEP_TIME confusion

669464Nov 29 2010 — edited Nov 30 2010

Hi All,

Please clear my doubts

Database version :10.2.0.3

recovery window of 30 days set on oct 30

I have set the recovery window to 30 days and all the backups of past 30 days are listed when i log in recovery catalog.But when i log in with target controlfile only 15 days backups are listed.My CONTROL_FILE_RECORD_KEEP_TIME=7 which is minimum 7 days.

That means if i login with controlfile then my recovery windows is becomming 15 days and when it is 7 days why controlfile i listing backups of 15 days?do i need to increase the CONTROL_FILE_RECORD_KEEP_TIME=30 to make it sync with rman catalog ?

In additon report obselete by cantrolfile listing backups from oct 30 to nov 14 as obselete

Regards

Edited by: hungry_dba on Nov 29, 2010 4:31 PM

This post has been answered by Uwehesse-Oracle on Nov 29 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2010

Added on Nov 29 2010

#general-database-discussions

9 comments

4,170 views