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: shutdown abort & consistent=Y

Re: shutdown abort & consistent=Y

From: Michael Ho <infoage_at_hk.super.net>
Date: Thu, 04 Feb 1999 12:31:05 +0800
Message-ID: <36B92289.8FC14A87@hk.super.net>


The shutdown immediate should serve the same purpose ? Why ABORT ? Shutdown time or some special locking problem ?

Doug Cowles wrote:

> It seems as though a common practice to kick off users is to shutdown
> abort,
> bring the database back up in restricted mode, and then shutdown normal.
>
> Is this really safe? If no checkpoints are done, can't you lose stuff
> in memory?
> Also, if you have time - does consistent really enforce referential
> integrity?
> Someone on this group told me a while ago that consistent only enforced
> point
> of time per table, not the entire database.
> Any comments?
> Dc.
Received on Wed Feb 03 1999 - 22:31:05 CST

Original text of this message

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