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

Home -> Community -> Mailing Lists -> Oracle-L -> shutdown for backup : pro's and con's

shutdown for backup : pro's and con's

From: Pat Howe - Contractor <pat.howe_at_Terabeam.com>
Date: Thu, 7 Dec 2000 11:01:54 -0800
Message-Id: <10703.123958@fatcity.com> 





I would like to be convinced one way or the other on the following issue : 
What is the best way to take a database down for a cold backup ?
 


SHUTDOWN ABORT



STARTUP RESTRICT



SHUTDOWN NORMAL



<BACKUP>




or



SHUTDOWN IMMEDIATE



<BACKUP>




I have seen both widely used.


I have always stayed away from the ABORT option because I am uneasy about
taking any database down this way (hard).
I am looking for a dialog on the pro's and con's of each approach.
ie: Any horror stories about taking down with the ABORT option ?
Received on Thu Dec 07 2000 - 13:01:54 CST












Original text of this message













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