Home » Server Options » Data Guard » REMOTE_ARCHIVE_ENABLE
REMOTE_ARCHIVE_ENABLE [message #74448] Sun, 12 December 2004 20:06 Go to next message
ramya
Messages: 87
Registered: August 2002
Member
Hi
If i have few doughts about dataguard.
if i set this parameter it will apply the logs to the standby database mandatory

LOG_ARCHIVE_DEST_2='SERVICE=standby MANDATORY REOPEN=15'

Then what is the significance of this paramter.it will also apply the logs in remote destination automatically( log transport services)
REMOTE_ARCHIVE_ENABLE=true
if i am wrong pls pardon me.thnks in advance
Re: REMOTE_ARCHIVE_ENABLE [message #74453 is a reply to message #74448] Tue, 14 December 2004 02:47 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

The MANDATORY argument indicates that Oracle must archive (not apply!) this log file to the remote machine before reusing the log file group. By implication this will cause your production database to hang when there are network problems.

Log files are applied on the standby site by the MRP (physical standby) or LSP (logical standby) process.

Best regards.

Frank
Previous Topic: Tuning Standby Database - roll forward
Next Topic: failover
Goto Forum:
  


Current Time: Thu Mar 28 03:51:50 CDT 2024