ORA-19502 and RMAN
Date: Mon, 15 Nov 2010 10:01:12 -0600
Message-ID: <5AB39101E7EA7841BDE65D8E04BBD2A4AFA953_at_CMBFISLTC13.FNFIS.COM>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 15 2010 - 10:01:12 CST