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