Jan 13, 2015 - The script will list all RMAN backups that have finished in the last 24 hours and are FULL, you get the status, start time and end time. May 11, 2014 - If we want to track the process of rman which is currently running. Use the following query to check backup is completed successfully or not.
I've taken backup of datafiles in 31.12.2013. It completed datafile backups successfully, but archivelog backups failed.
Now, I want to determine what archivelogs should I backup to be sure that my database will be recoverable after restoring 31.12.2013 backup of datafiles.
kupakupa
9621212 gold badges3333 silver badges5151 bronze badges
2 Answers
You may try (requires at least Oracle 10g):
You'll need at least the archive logs generated during the entire backup operation.
A quick demo:
Note the scn min-max indications in the restore ... preview output:
Media recovery start SCN is 2475111 Recovery must be done beyond SCN 2475373 to clear datafile fuzziness
So to go beyond the indicated scn, we search for archived logs that contain scn 2475373 + 1.
If you want to verify manually, check the following MOS Note:
How to determine minimum end point for recovery of an RMAN backup (Doc ID 1329415.1)
How to determine minimum end point for recovery of an RMAN backup (Doc ID 1329415.1)
Dimitre RadoulovDimitre Radoulov
Depending on your requirements and what other backups you have done since then, you could use (from http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89594):
These will tell you which files you need to backup to provide 'n' days worth of restore capability or 'n' redundancy.
Phil SumnerPhil Sumner