RE: ORA-19502 and RMAN
- From: "Blanchard, William G" <William.Blanchard@xxxxxxxxxxxxx>
- To: "Pradipta Saha" <psaha.stu@xxxxxxxxx>
- Date: Mon, 15 Nov 2010 11:30:34 -0600
Disk
From: Pradipta Saha [mailto:psaha.stu@xxxxxxxxx]
Sent: Monday, November 15, 2010 11:25 AM
To: Blanchard, William G
Subject: Re: ORA-19502 and RMAN
Where r u backing ur archivelog !! tape or disk ??
Prad
On Mon, Nov 15, 2010 at 11:01 AM, Blanchard, William G
<William.Blanchard@xxxxxxxxxxxxx> wrote:
Greetings,
I am doing an RMAN backup on RHEL 5 of my archivelogs every 10 minutes
to keep the mount point from filling up.
crosscheck archivelog all;
backup as compressed backupset archivelog all
format='/oracle_backup_<Database>/rman/%U.arc' delete all input;
delete noprompt obsolete;
However, I'm getting an ORA-19502 when the database tries to write to
the archivelogs that were just backed up.
RMAN Log:
...
validation succeeded for archived log
archived log file
name=/ora03<database>/arch/<database>_3592_1_726663173.arc RECID=3582
STAMP=735125601
...
Starting backup at 15-NOV-10
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
...
input archived log thread=1 sequence=3592 RECID=3582 STAMP=735125601
...
channel ORA_DISK_2: starting piece 1 at 15-NOV-10
channel ORA_DISK_2: finished piece 1 at 15-NOV-10
piece handle=/oracle_backup_<database>/rman/a2lt286f_1_1.arc
tag=TAG20101115T093509 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:02:45
channel ORA_DISK_2: deleting archived log(s)
...
archived log file
name=/ora03<database>/arch/<database>_3592_1_726663173.arc RECID=3582
STAMP=7351256
Alert Log Error:
ORA-19502: write error on file
/ora03<database>/arch/<database>_3592_1_726663173.arc, block number
12289 (block size=512)
Any idea why Oracle would be trying to write to an archivelog that RMAN
has just backed up and deleted? I did a list backup of archivelog x and
can see that it was indeed backed up.
Thank you,
WGB
_____________
The information contained in this message is proprietary and/or
confidential. If you are not the intended recipient, please: (i) delete
the message and all copies; (ii) do not disclose, distribute or use the
message in any manner; and (iii) notify the sender immediately. In
addition, please be aware that any message addressed to our domain is
subject to archiving and review by persons other than the intended
recipient. Thank you.
_____________
_____________
The information contained in this message is proprietary and/or confidential.
If you are not the intended recipient, please: (i) delete the message and all
copies; (ii) do not disclose, distribute or use the message in any manner; and
(iii) notify the sender immediately. In addition, please be aware that any
message addressed to our domain is subject to archiving and review by persons
other than the intended recipient. Thank you.
_____________
Other related posts:
