RE: Current archiver destination

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 [mailto:vadimbobrov_at_gmail.com] Sent: Friday, May 19, 2006 7:58 AM
To: Schultz, Charles; oracle-l_at_freelists.org 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 [mailto:sac_at_uillinois.edu]
> Sent: Friday, May 19, 2006 4:17 PM
> To: vadimbobrov_at_gmail.com; oracle-l_at_freelists.org
> 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: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vadim Bobrov
> Sent: Friday, May 19, 2006 7:02 AM
> To: oracle-l_at_freelists.org
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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