Re: ORA-19502 and RMAN
- From: Wayne Smith <wts@xxxxxxxxx>
- To: William.Blanchard@xxxxxxxxxxxxx
- Date: Mon, 15 Nov 2010 14:13:50 -0500
I'm wondering if you might have multiple versions of your script running at
the same time.
Since the crosscheck/delete can be fairly long running, why run them so
often?
Cheers, Wayne
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.
> _____________
>
Other related posts:
