Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: The Admin's point of view on DB users best practices
Rick Denoire wrote:
[...snip...]
> 6) Always do an "insert /*+ APPEND */ " into an empty table, perhaps
> in nologging mode.
TRADE-OFFS Do you realize that after NOLOGGING is used, you've just rendered the previous hotback useless past this point in time? Since the data being inserted is NOT written to the redo logfiles, any recovery of this instance can only be made valid to the time of when NOLOGGING is used.
Our inhouse Best Practices Manual explicitly states that developer should NEVER use NOLOGGING, because we desire to maintain a continous recovery DB for failover capability. Received on Sat Feb 14 2004 - 09:17:51 CST