Using Control File as repository for RMAN. I am not seeing old backups from 4 or more days ago. How do I see at least 4 - 7 days of backup?
Posted on 2011-09-02
Hi, I'm using the control file as my RMAN repository and I have done 7 or more backups on my development database. When I go into RMAN and do a 'list backup' I only see 3 days worth of backups. I did some reading and I came across a parameter called 'CONTROL_FILE_RECORD_KEEP_TIME' and found (show parameter CFRKT(shorten) that the value set in my database is 7 for seven days which is the default setting to keep reusable records which include backup records. After doing some more reading I found out that the 'CFRKT' parameter doesn't really relate to RMAN. My question is how do I maintain at least 7 days of backup records in the Control file without the use of a recovery catalog? And is there a way for me to add back the backups if I can restore them to their old backup location? I'm getting ready to start testing some recovery scenarios and it will look bad it I can't go back a few days ago, this problem will justify the continued use of hot backups instead of moving forward to 11g.