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