Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data Guard and nologging
sybrandb_at_hccnet.nl wrote:
> Comments embedded
>
>
> On Fri, 06 Apr 2007 21:14:56 GMT, Chuck
> <skilover_nospam_at_bluebottle.com> wrote:
>
>> Oracle says that putting a table into nologging mode on the primary >> database in a data guard configuration can invalidate the standby.
>> understand DG correctly, it's just a database that's perpetually in >> recovery mode until activated. Suppose you have a few tables that get >> truncated and rebuilt every time they are used, and there are no foreign >> key constraints involved, will that harm the standby database?
>> Obviously no DML would get pushed to the standby,
I was under that impression.
>
> but if the tables are
>> truncated and rebuilt every time they're used, who cares? >> >> Assume that in this case global temporary tables cannot be used. (The >> app that uses them is not single threaded or in a single session.)
GTT was my first choice but it's a 3rd party application that can't be modified and doesn't perform all it's operations in a single session.
Thanks for the reply. Received on Fri Apr 06 2007 - 16:44:33 CDT