Re: Standby abuse

From: bao jiejie <>
Date: Sat, 8 Nov 2008 08:09:19 +0800
Message-ID: <>

I agree with Dominic,physical standby db files will be useful while you make some recover task, Logical standby can not support bfile,rowid, user defined types, and some types in the table which you can not distinguish by rows,
if your database do not contain those object which not be supported by Logical standby,
you can also try logical one.

And the new feature of 11g is that it can provide read ability while still applying the logs,
that means in 11g, physical standby db can also provide you for read access.

On Sat, Nov 8, 2008 at 7:18 AM, Dominic Delmolino <> wrote:
> Dick,
> Good point about using the files from the standby for media recovery
> operations on the primary...
> On Fri, Nov 7, 2008 at 4:10 PM, Goulet, Richard <>
> 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

Received on Fri Nov 07 2008 - 18:09:19 CST

Original text of this message