Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Q] what differtent between logical standby database and physical standby DB?

Re: [Q] what differtent between logical standby database and physical standby DB?

From: Tim Johnston <tjohnston_at_quallaby.com>
Date: Thu, 08 Apr 2004 13:00:26 -0400
Message-ID: <4075852A.6070803@quallaby.com>


Bobak, Mark wrote:

>Um, in the physical standby case, aren't the archivelogs simply =
>transferred to the standby server in their entirety?
>

Yes and no... Physical standby in 9i has three different "modes"... The default mode is the same as physical standby in 8i... Archive logs are shipped to the standby and applied... This is the "maximum performance" mode... However, the two additional modes ("maximum protection" and "maximum availability") create "standby redo logs" on the standby server... Changes are written to both sets of redo logs (online redo on the primary and standby redo logs on the secondary)... When a log switch occurs on the primary, the standby log is also switched and applied to the secondary... Lots of little details there that I'm glossing over... Lots of info in the Dataguard manual...

Tim



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Apr 08 2004 - 11:59:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US