REMOTE_ARCHIVE_ENABLE [message #74448] |
Sun, 12 December 2004 20:06 |
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 |
Frank Naude
Messages: 4587 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
|
|
|