Author Archives

RMAN Infatuation?

Lately, I am becoming infatuated with RMAN again. Have you ever run “restore database preview”? Are you curious about how the recovery SCN are determined? Media recovery start SCN is 1515046 Recovery must be done beyond SCN 1515051 to clear datafile fuzziness If you are, then I will demonstrate this for you. RMAN LEVEL0 backup…

RMAN – Validating Archivelog Backup

There are many posts out there about validating backup. However, none seem to address some recent concerns a client of mine had. Currently, backup validation is performed once a week and the question asked,  “How to validate all archivelog backup?” List Backups – [D}atafile and [A]rchivelog backup from Incremental Level 0/1 RMAN> list backup summary;…