DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: RMAN - A "delete archivelog.." incorrectly got rid of an archivelog?!

Threaded View

  1. #1
    Join Date
    Oct 2002
    Posts
    807

    RMAN - A "delete archivelog.." incorrectly got rid of an archivelog?!

    One of my "delete archivelog all backed up 2 times to sbt" scripts behaved whackily all of a sudden. It appears to have gotten rid of an archivelog file (1_3884.dbf) that had never been backedup!

    Here's the background -
    I've got 2 scripts scheduled via cron. One, backups up archivelogs to tape. The other deletes archivelogs that have been backed up twice already. In this instance, the latter incorrectly got rid of an archivelog file that was NEVER backedup to tape!

    Note : I messed up with the scheduling..both the scripts ran at the SAME time (at 10am today). However, that doesn't explain why the latter script would get rid of an archivelog (1_3384.dbf) that had NEVER been backed up. The relevent archivelog 1_3384 got generated at 10am as well.

    I've attached the relevent logfiles in a textfile.

    1) Script 1 ( DWDEV_periodic_arch_bkup.rman) is simply

    run
    {
    allocate channel t1 type 'sbt_tape' parms
    'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/DWDEV/tdpo.opt)';
    allocate channel t2 type 'sbt_tape' parms
    'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/DWDEV/tdpo.opt)';
    BACKUP
    format 'dwdev_periodic_arch_bkup_%t_%s_%p'
    tag='DWDEV periodic arch log bkup'
    ARCHIVELOG all not backed up 2 times;
    release channel t1;
    release channel t2;
    }
    ==========================================================
    2) Script 2 ( rm_bkedup_arch_log.rman) is

    run {
    delete noprompt archivelog all backed up 2 times to sbt;
    }
    ==================================

    I've opened a TAR..it has been in an open status for the past hour and a half. Hasn't even got assigned to an analyst! I give up on them.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width