473,606 Members | 2,453 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
Jul 19 '05 #1
0 2920

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
11117
by: sunilwarrier | last post by:
I found a few documents on this topic, but didn't resolve my issue. I am trying to restore an RMAN backup to a different host (with a differnet instance name) from where the backup was taken. And while running it gives the following error: ORA-19505: failed to identify file "g:\......fullback.546.1" ORA-27041: unable to open file
1
4644
by: steve | last post by:
Hi, I am using the java database manager on oracle 9i linux , to monitor and modify my oracle 9i system. there is a wizard that allows the setting up of an rman job. I had setup a backup script that ran a partial backup mon-sat & a full backup on sunday. i recently wanted to use the wizard to setup a script for another database but some how the script that the wizard uses as a basis has been corrupted.
1
5090
by: RYAN | last post by:
Hi All, I am new to Oracle and I have some question that I hope that someone out there can help me. I have heard the Oracle Rman can do replication of Archives logs. In this way, one can setup some sort or Oracle Instances replication accross 2 machine at different sites. 1. Does amyone know how is the performance of this method of replication as
2
2499
by: Tho Nguyen | last post by:
Hi, folks! I am new to RMAN and now trying to configure it. There is one issue concerning me. Let's say I backup the target database every 6:PM and the database generates about 100 archived logs every day. So what happens if the database crashs at 5PM? I have the backup at 6PM of the last day only and no backup of archive logs generated between that time. Have anynone experienced that any what is your solution?
0
1208
by: gohel | last post by:
I have cofigured rman on linux with oracle 9i (catdb) as revecory catalog db and target db is on win XP with oracle 9i in archive log mode , Now problm is I want backup of target DB (targdb) using rman installed on catdb and backup files to be stored in /backup folder in linux. can anybody help Thanks
0
4004
by: gunsbong | last post by:
hello again everybody.. i just copied the backup file from production to another server with the same config with the production...when i restore the copied backup file this message appears... RMAN> restore database; Starting restore at 17-SEP-07 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=2183 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2:...
0
378
by: TX-DBA | last post by:
#####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
12
4271
by: =?ISO-8859-1?Q?Joaqu=EDn_Zuazo?= | last post by:
I'm trying to find what character was pressed, using an accent with a dead letter, e.g an á, on an input box. I have made an small program to check the keyboard events keydown, keypress and keyup, and only the keyup one is fired two times. The first with a 0 keycode and the characte code just later. No keydown or keypress events, and it is not enough information to know what character was really pressed. It happens with Firefox ...
9
11408
by: mdfaraz | last post by:
SIR AS IAM USING ORACLE 10G RELEASE 2 IN RED HAT LINUX AS4, AS I CREATED ONE DATABASE NAMED AS <BSNL>..AND THE DEFAULT DATABASE IS ORCL. I ALREADY SET BSNL IN TNSNAMES.ORA AND ALSO IN LISTENER.ORA. PLZ TEL ME VERY STARTING PROCEDURE TO CONNET TO RMAN. IF IAM ENTERING AS $rman iam getting as cant open target database... please help me.
0
8024
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8449
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8432
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8105
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
6781
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5466
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2451
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1561
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1305
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.