Re: Does Every Table Need a Primary Key for Data Guard (Physical Standby)?

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 07 Apr 2005 15:08:05 GMT
Message-ID: <p1c5e.20612$zl.5387@newssvr13.news.prodigy.com>

GeoPappas wrote:
> I read that every table in a Data Guard (Logical Standby) needs to have
> a primary key. Is this also true for a Data Guard (Physical Standby)?
>
> FYI: Using 10gR1 on Solaris 2.9
>

No. Physical standby (redo apply) is an image copy of the primary datafiles (but not tempfiles or controlfiles). Logical standby uses SQL apply (logical change records - LCR) which is why primary keys and supplemental logging is required -- and also why it is much more flexible than physical standby.

-Mark Bole Received on Thu Apr 07 2005 - 10:08:05 CDT

This message: [ Message body ]
Next message: Volker Hetzer: "Re: Does Every Table Need a Primary Key for Data Guard (Physical Standby)?"
Previous message: ed.stevens_at_comcast.net: "Sporadic ORA-04030 , part tres"
In reply to: GeoPappas: "Does Every Table Need a Primary Key for Data Guard (Physical Standby)?"
Next in thread: Volker Hetzer: "Re: Does Every Table Need a Primary Key for Data Guard (Physical Standby)?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US