Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: hanging shutdowns
I definitely agree, the shutdown is not the problem, it is doing what it is supposed to do in order to maintain data integrity and preserve transactions. The real questions is 'why do you shutdown at all??', I haven't been forced to perform a cold backup on a schedule in years. I thought 7X24 really meant 7X24. If the production environment can deal with the downtime necessary to perform cold backups, then couldn't that time be used to perform batch transactions or some other necessary task.
-- http://www.freelists.org/webpage/oracle-l Received on Mon Feb 27 2006 - 18:13:11 CSTThe easiest way would be shutdown abort; startup restrict; shutdown immediate; In fact I have suspicion that this three step process will not be much faster than a simple shutdown immediate. But hey, it is still dangerous to restart database for backup purposes, what if database will not startup from the script for some reason. It is much safer to do online backups, and you can prepare and test all the scripts for online backup by next Sunday. At least you can test restore of small database, and partial restore of a large one. On 2/27/06, Robyn <robyn.sands@gmail.com> wrote:Hello all, Databases are Oracle 9.2.0.6 on HP-UX approximately a TB in size. (some slightly bigger, some slightly smaller) recommendations appreciated ...-- Best regards, Edgar Chupit callto://edgar.chupit -- http://www.freelists.org/webpage/oracle-l