dbTalk Databases Forums  

dead.letter in my RMAN backuppiece

comp.databases.oracle comp.databases.oracle


Discuss dead.letter in my RMAN backuppiece in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
TX-DBA
 
Posts: n/a

Default dead.letter in my RMAN backuppiece - 09-15-2004 , 10:16 AM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.