How to verify RMAN backups are good to recover,restore a database?
990636Mar 14 2013 — edited Mar 14 2013When a database is backed up,how we know that the data backed up by rman is good for RECOVER.
I use catalog database to backup the databases.
RMAN>list backup;
rman>list backup summary;
I have set my RETENTION POLICY TO RECOVERY WINDOW OF 90 DAYS;
control_file_record_keep_time of 7 days.
What is the difference between Retention policy and control_file_record_time?
that means RMAN showing me all 90days backups right?
is there any list command which shows like 2 or 3 days backups which are backed up.I can know that info from SQL
http://gavinsoorma.com/2009/07/rman-script-to-check-backups/
just wondering is there any command from RMAN list commands which gives the last days backups.
RMAN>list recoverable backup;
is this above command shows the backups which are used for recover and restore the database?
I need list command to crosscheck the data am backed up from RMAN are good to recover the database.