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

  • From: Tim Johnston <tjohnston@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 08 Apr 2004 13:00:26 -0400

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...


Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: