RE: Current archiver destination

  • From: "Vadim Bobrov" <vadimbobrov@xxxxxxxxx>
  • To: "'Schultz, Charles'" <sac@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 19 May 2006 17:01:29 +0400

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) 

> 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.

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


Other related posts: