Oracle says that putting a table into nologging mode on the primary
database in a data guard configuration can invalidate the standby. If I
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, 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.)
Received on Fri Apr 06 2007 - 16:14:56 CDT
