Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: The Admin's point of view on DB users best practices

Re: The Admin's point of view on DB users best practices

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 14 Feb 2004 07:17:51 -0800
Message-ID: <v_qXb.40806$P17.33929@fed1read03>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US