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

From: Tim Johnston <tjohnston_at_quallaby.com>
Date: Thu, 08 Apr 2004 11:32:18 -0400
Message-ID: <40757082.70109@quallaby.com>

I haven't played with Logical Standby but I did read a little about it... Some other items that are mentioned in the docs...

Logical Standy will allow you to exclude objects from replication

So, you can replicate only the portion of the database you care about

2) Logical Standby will allow you modify the objects in the standby database

For example, you could replicate your OLTP database using logical standby and use the standby as a reporting instance... Since the demands of the reporting instance are different, you could add different indexes, views, MV and such to the standby that do not exist in the primary...

3) Logical Standby has a number of datatype and object type limitations

No IOT's... No tables with compression... No LONG's, varrays, nested tables, user defined types etc...

However, someone who has actually played with this may be able give some insight as to whether this actually works as advertised...

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 - 10:31:42 CDT