Re: Standby abuse
- From: "Dominic Delmolino" <ddelmoli@xxxxxxx>
- To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- Date: Fri, 7 Nov 2008 17:51:43 -0500
Dick,
I'd argue that I could definitely off-load my backup needs if I only cared
about the data, and not so much of the physical aspects of how it's laid
out. I generally don't like to use ROWIDs as data values since they can
change, and I can't think of a reason why I'd care if the object id's were
different -- can you give me an example?
On Fri, Nov 7, 2008 at 4:10 PM, Goulet, Richard
<Richard.Goulet@xxxxxxxxxxx>wrote:
> Dominic,
>
> You can't use a logical standby to off load your backup needs. This is
> because a logical does not replicate the original database, but only the
> transactions therein. Rowid's and object id's between the two will be
> different so you can't just move a data file from your logical standby to
> the primary for recovery purposes. A physical standby is the only way to do
> that since it does maintain rowid's and the like.
>
>
> *Dick Goulet***
> Senior Oracle DBA
> PAREXEL International
> 978.313.3426
> * information transmitted in this communication is intended only for the
> person or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited. If you
> received this in error, please destroy any copies, contact the sender and
> delete the material from any computer.*
>
>
>
> ------------------------------
>
--
Dominic Delmolino
Other related posts:
