OraFAQ Forum: Data Guard » Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE

Home » Server Options » Data Guard » Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST [message #354149]

Thu, 16 October 2008 10:38

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 ?

Report message to a moderator

Re: Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST [message #354198 is a reply to message #354149]

Thu, 16 October 2008 23:31

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams208.htm#i1134342

Regards
Michel

Report message to a moderator

Re: Query on LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST [message #354298 is a reply to message #354149]

Fri, 17 October 2008 08:47

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.

Report message to a moderator

Previous Topic:	data guard...!!!!
Next Topic:	physical standby database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 27 22:32:08 CDT 2025