RE: ORA-19502 and RMAN

WGB -----Original Message-----
From: David Barbour [mailto:david.barbour1_at_gmail.com] Sent: Monday, November 15, 2010 5:04 PM
To: Blanchard, William G
Cc: oracle-l_at_freelists.org
Subject: Re: ORA-19502 and RMAN

What version of Oracle are you on? Are you running a standby database or RAC with this?

On 11/15/10, Blanchard, William G <William.Blanchard_at_fisglobal.com> 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.

--
http://www.freelists.org/webpage/oracle-l