Home » Server Options » Data Guard » Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST
Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST [message #354149] Thu, 16 October 2008 10:38 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am not able to get much details about the use of STANDBY_ARCHIVE_DEST . Can anyone clarify the same ?
Is it the place where archived logs of standby redo logs are stored ?

In that case if we have both STANDBY_ARCHIVE_DEST and LOG_ARCHIVE_DEST set then whether both of them are used , if so in which cases each destination is used ?

Is it possible to specify LGWR in LOG_ARCHIVE_DEST_n parameters without having standby redo logs ?




Re: Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST [message #354198 is a reply to message #354149] Thu, 16 October 2008 23:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams208.htm#i1134342

Regards
Michel
Re: Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST [message #354298 is a reply to message #354149] Fri, 17 October 2008 08:47 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If both STANDBY_ARCHIVE_DEST and LOG_ARCHIVE_DEST_n are specified, then STANDBY_ARCHIVE_DEST will be used, however it is sufficient enough to simply use LOG_ARCHIVE_DEST_n.

STANDBY_ARCHIVE_DEST is actually deprecated in 11g.
Previous Topic: data guard...!!!!
Next Topic: physical standby database
Goto Forum:
  


Current Time: Thu Mar 28 12:03:24 CDT 2024