RE: Current archiver destination

From: Schultz, Charles <sac_at_uillinois.edu>
Date: Fri, 19 May 2006 07:17:28 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34171D6D4@ADMINMAIL1.ui.uillinois.edu>

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 Received on Fri May 19 2006 - 07:17:28 CDT