One additional fact. In logical standby some data types (ie. long) are
not supported.
(at least in 9i).

KAzi

Amar Shah wrote:
> Hi,
>
> The difference between physical and logical standby is in the way the
> changes from the primary are applied. Both created as an exact image
of the
> primary database. Both receive redo logs from the primary database. The
> difference is that a physical standby is mounted (but not open) and
applies
> the received redo logs just as in the case of media failure recovery. A
> logical standby reconstructs SQL statements from the received redo
logs and
> executes them. A logical standby is (must be) opened and can with some
> limitations be used for reporting or other purposes. A physical standby is
> mounted and generally cannot be used for any other purposes. You can
> however switch temporarily to read-only mode and query it but
> synchronization with the primary will be paused until you return to the
> recovery mode. In 10g Rel. 2 you can also open it read-write and then
> flashback to its original state
>
> Best regards,
> Amar Shah
>
>
>

>
"YONGLONG_LI"
>
<oracledba-ezmlms
>
hield-x59707836.x To
> [Email Address Removed] "LazyDBA
Discussion"
> A.com> <[Email address
protected]
>
cc
> 29/02/2008
10:44
> AM
Subject
> RE: RAC
10g
>

>

>

>

>

>

>
>
>
> Dears:
> Pls tell me what difference are both Physical standby and Logical
> standby database.
> Thanks!
>
> -----Original Message-----
> From: Menaka
> [mailto:oracledba-ezmlmshield-x18955266.[Email address protected]
> Sent: Friday, February 29, 2008 12:49 PM
> To: LazyDBA Discussion
> Subject: RAC 10g
>
> Thanks Amar Shah
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>



Oracle LazyDBA home page