I am testing out RMAN (8.1.7). I am trying out various "sanity check" scenarios. In this test I wanted to see if RMAN can detect that our backup is not complete : ie; it is missing a "backed up" archive log file.
To do this I did the following : * STEP1 - Backed up the database using RMAN (full backup) * STEP2 - Physically Deleted a backup archive log file * STEP3 - Tried (unsuccessfully) to get RMAN to recognize that it has a problem STEP1 Full database backupset including control and archive logs. STEP2 /u03/backup/rman > -rw-r----- 1 oracle oinstall 1449984 Mar 12 15:15 ctl_fincopy.snp -rw-r----- 1 oracle oinstall 241295872 Mar 12 15:23 TESTDB_BACKUPSET_46_1_456333304 -rw-r----- 1 oracle oinstall 339059200 Mar 12 15:23 TESTDB_BACKUPSET_44_1_456333303 -rw-r----- 1 oracle oinstall 482697728 Mar 12 15:23 TESTDB_BACKUPSET_45_1_456333304 -rw-r----- 1 oracle oinstall 2560 Mar 12 15:23 FINCOPY_ARCHLOGS_48_1_456333832 -rw-r----- 1 oracle oinstall 7680 Mar 12 15:23 FINCOPY_ARCHLOGS_47_1_456333832 /u03/backup/rman > rm FINCOPY_ARCHLOGS_47_1_456333832 rm: remove FINCOPY_ARCHLOGS_47_1_456333832 (yes/no)? y /u03/backup/rman > total 2080262 -rw-r----- 1 oracle oinstall 1449984 Mar 12 15:15 ctl_fincopy.snp -rw-r----- 1 oracle oinstall 241295872 Mar 12 15:23 TESTDB_BACKUPSET_46_1_456333304 -rw-r----- 1 oracle oinstall 339059200 Mar 12 15:23 TESTDB_BACKUPSET_44_1_456333303 -rw-r----- 1 oracle oinstall 482697728 Mar 12 15:23 TESTDB_BACKUPSET_45_1_456333304 -rw-r----- 1 oracle oinstall 2560 Mar 12 15:23 FINCOPY_ARCHLOGS_48_1_456333832 STEP3 VALIDATE RESTORE I thought that "Restore Validate" would detect a problem. But it did NOT detect that I was missing backed up archive logs. BUT This made sense because RMAN does not know that I physically deleted a file. CROSSCHECK BACKUP Therefore I tried CROSSCHECK BACKUP BUT This only checks for BACKUPSETS and not ARCHIVELOGS. ??? How do get RMAN to verify that all the 'backed up archivelogs' actually still exist ? IE; That it has all the archive logs it needs to Rollforward. How do I get RMAN to acknowledge that we have a problem ? Maybe I am asking to much of RMAN - but hey - it does this for BackupSets (crosscheck backup) - why not archive logs. PS : I attempted to perform an RMAN recovery and low-and-behold RMAN recognized that I was missing some REDO. BUT you do not want to know this at this time. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: recover RMAN-03002: failure during compilation of command RMAN-03013: command type: recover(4) RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of log thread 1 seq 416 scn 493178 found to restore RMAN-06025: no backup of log thread 1 seq 415 scn 493176 found to restore RMAN-06025: no backup of log thread 1 seq 414 scn 493172 found to restore _________________________ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Olympia, WA 98507 Phone : 360.493.6284 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).