Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: shutdown abort & consistent=Y
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