dead.letter in my RMAN backuppiece

From: TX-DBA <lancegrieb_at_yahoo.com>
Date: 15 Sep 2004 08:16:24 -0700
Message-ID: <a95941b3.0409150716.6d535c37_at_posting.google.com>

#####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_21214.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.



########################Orginal

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

########################Tuesday

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 Received on Wed Sep 15 2004 - 17:16:24 CEST