ORA-19502 and RMAN

From: Blanchard, William G <William.Blanchard_at_fisglobal.com>
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-l
Received on Mon Nov 15 2010 - 10:01:12 CST

Original text of this message