dead.letter in my RMAN backuppiece

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • TX-DBA

    dead.letter in my RMAN backuppiece

    #####Background
    1) CRONJOB runs 2 RMAN shell scripts at 3AM

    backup_begin.sh- export and rman backups
    report_begin.sh- list rman reports


    My report_begin.sh script, which was messed up, was sending/writing
    the dead.letter info to the RMAN backupset peices, thats correct! It
    was over-writting them and giving a new file timestamp which was newer
    than the directory time stamp?? I was shocked when I did a cat command
    on a old RMAN backup piece and saw my dead.letter email. The
    non-cronjob RMAN files (82,83) I ran manually are not effected.

    It also corrupted some data files too.

    Fri Sep 10 21:53:57 2004
    Errors in file /u01/app/oracle/admin/NEPTUNE/bdump/neptune_smon_21 214.trc:
    ORA-01565: error in identifying file
    '/u02/oradata/NEPTUNE/undotbs01.dbf'
    ORA-27046: file size is not a multiple of logical block size
    Additional information: 1


    Hense a restore/recovery on 2 day old backups.

    I fixed the email portion of the script and its working and things are
    fine, but how could this happen?

    Guess:
    1) Both RMAN scripts are run at the same time?
    2) I found a secret email feature.
    3) Some global variable in both shells got mixed up.



    ############### #########Orgina l
    total 36786272
    -rw-r----- 1 oracle oinstall 4976005120 Sep 8 03:40
    ora_df536297778 _s73_s1
    -rw-r----- 1 oracle oinstall 2993217536 Sep 8 03:42
    ora_df536298025 _s74_s1
    -rw-r----- 1 oracle oinstall 722118039 Sep 10 03:00
    ora_df536298140 _s75_s1
    -rw-r----- 1 oracle oinstall 716756375 Sep 10 03:00
    ora_df536298195 _s76_s1
    -rw-r----- 1 oracle oinstall 4980387840 Sep 9 03:37
    ora_df536384000 _s77_s1
    -rw-r----- 1 oracle oinstall 2996527104 Sep 9 03:39
    ora_df536384258 _s78_s1
    -rw-r----- 1 oracle oinstall 723490199 Sep 10 03:00
    ora_df536384373 _s79_s1
    -rw-r----- 1 oracle oinstall 716756375 Sep 10 03:00
    ora_df536384428 _s80_s1

    ############### #########Monday
    total 18633032
    -rw-r--r-- 1 oracle oinstall 2976 Sep 13 03:00
    ora_df536297778 _s73_s1
    -rw-r--r-- 1 oracle oinstall 2976 Sep 13 03:00
    ora_df536298025 _s74_s1
    -rw-r--r-- 1 oracle oinstall 2976 Sep 13 03:00
    ora_df536384000 _s77_s1
    -rw-r--r-- 1 oracle oinstall 2976 Sep 13 03:00
    ora_df536384258 _s78_s1
    -rw------- 1 oracle oinstall 4988182528 Sep 11 13:45
    ora_df536593254 _s82_s1
    -rw------- 1 oracle oinstall 3006152704 Sep 11 13:47
    ora_df536593530 _s83_s1
    -rw------- 1 oracle oinstall 775228320 Sep 13 03:00
    ora_df536593635 _s84_s1
    -rw------- 1 oracle oinstall 765819808 Sep 13 03:00
    ora_df536593680 _s85_s1


    ############### #########Tuesda y
    total 18633064
    -rw-r--r-- 1 oracle oinstall 4460 Sep 14 03:00
    ora_df536297778 _s73_s1
    -rw-r--r-- 1 oracle oinstall 4460 Sep 14 03:00
    ora_df536298025 _s74_s1
    -rw-r--r-- 1 oracle oinstall 4460 Sep 14 03:00
    ora_df536384000 _s77_s1
    -rw-r--r-- 1 oracle oinstall 4460 Sep 14 03:00
    ora_df536384258 _s78_s1
    -rw------- 1 oracle oinstall 4988182528 Sep 11 13:45
    ora_df536593254 _s82_s1
    -rw------- 1 oracle oinstall 3006152704 Sep 11 13:47
    ora_df536593530 _s83_s1
    -rw------- 1 oracle oinstall 775229804 Sep 14 03:00
    ora_df536593635 _s84_s1
    -rw------- 1 oracle oinstall 765821292 Sep 14 03:00
    ora_df536593680 _s85_s1
Working...