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 immediate or abort for cold-backup?

Re: shutdown immediate or abort for cold-backup?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 17 Aug 2001 17:55:53 -0700
Message-ID: <8096153.0000d289.015@drn.newsguy.com>


In article <pXhf7.2923$0z.44549_at_news11-gui.server.ntli.net>, "Keith says...
>
>> You should not trust in a backup after a shutdown abort.
>
>Bollocks
>
>

you know, just because something appears to work in a test or two does not mean that it works and is the right, proper thing to do....

Ok, to be more clear:

you should not trust a backup after a shutdown abort without a startup/shutdown normal|immediate when in archivelog mode.

A shutdown abort can result in fractured blocks. A fractured block is where the head != tail of the block. In hot backup mode, we take special pains to avoid this issue by logging additional information to the online redo log. This additional information won't be there in this case. Media recovery could fail (not will, could -- do you want to risk it? I don't)

If you are in archivelog mode, don't shutdown abort and copy those files... do a startup/shutdown normal|immediate and then copy them.

If you are in noarchivelog mode -- make sure to backup your online redo if you do this (this is the ONLY time ever that you should -- nay have to -- back them up, normally it is an error to back them up)

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Fri Aug 17 2001 - 19:55:53 CDT

Original text of this message

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