Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Current archiver destination

RE: Current archiver destination

From: Schultz, Charles <>
Date: Fri, 19 May 2006 08:03:41 -0500
Message-ID: <>

I think we may have seen a similar situation, based on what you have shared so far. We also have 2 standbys, and found that one was taking much longer to write to than the other destinations, which quickly becomes a bottleneck for your archiver. Ironically, the one that was closer (geographically) was significantly slower due to slower disk.

Unfortunately, I still do not know of a way to determine exactly which destination is being written to at a specific point in time. I am willing to bet that some gurus on this list will know, though.

-----Original Message-----
From: Vadim Bobrov [] Sent: Friday, May 19, 2006 7:58 AM
To: Schultz, Charles; Subject: RE: Current archiver destination

Yes, I meant to which destination it is writing now (this second. In our case it could actually be a minute, we maintain 2 standbys)

> -----Original Message-----
> From: Schultz, Charles []
> Sent: Friday, May 19, 2006 4:17 PM
> To:;
> Subject: RE: Current archiver destination
> The way I understand it, the archiver writes to all "active"
> (ie, not marked as failed) destinations in a round-robin fashion. Do
> you mean exactly which destination at a precise split-second? I would
> be interested to know if Oracle maintains that granular of
> information.
> If you mean in general, you can either use "show parameter
> log_archive_dest" or select against v$archive_dest.
> Hope that is what you are looking for.
> -----Original Message-----
> From:
> [] On Behalf Of Vadim Bobrov
> Sent: Friday, May 19, 2006 7:02 AM
> To:
> Subject: Current archiver destination
> Hello,
> Does anybody know how to find out to which destination an archiver
> process is currently archiving to? (other than alert.log)
> Thanks
> Vadim
> --

Received on Fri May 19 2006 - 08:03:41 CDT

Original text of this message