RE: [Q] what differtent between logical standby database and physicalstandby DB?
- From: Riyaj Shamsudeen <rshamsud@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, oracledba@xxxxxxxxxxx
- Date: Thu, 08 Apr 2004 08:02:39 -0500
Redo logs supports physio-logical logging. Every bit change at the block
level will generate a change vector which is bundled together in a redo
record. In a physical standby database the changes are replayed using
these redo records, very similar to the database recovery. The structure
should not be altered in a way that can affect the log application, in
this mode.
In a logical standby, the SQL statements are stripped off and reexecuted
in the standby DB. Quest replication product is using this method for a
long time now.
There are many pros and cons to both. Name a few: logical standby db
will not propagate redo log corruption, db should be open for logical
standby etc.
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Thursday, April 08, 2004 7:32 AM
To: oracledba@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: [Q] what differtent between logical standby database and
physical standby DB?
I read document it mention logical standby DB use "sql statements apply"
and physical standby use "redo log apply". I got confuse. "redo log
aplly" should same like "sql statements apply", due to "redo log"
includes hundreds SQL statements.
Can anyone give me a hint?
Thanks.
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
-- Attached file included as plaintext by Ecartis --
-- Desc: Signature
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
