Dears:
Your description is very clear. Thanks to you!
But I have another problem, How to create and configure one logical
standby database for primary database?

-----Original Message-----
From: Amar Shah
[mailto:oracledba-ezmlmshield-x96386989.[Email address protected]
Sent: Friday, February 29, 2008 1:19 PM
To: LazyDBA Discussion
Subject: RE: RAC 10g


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