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.

I would recommend spending some time on hot backups and showing your boss that the software is a little smarter these days and a complete, point in time/ or some other time recovery is easy. Take a few days/weeks and show him that you can give him an exact copy of his production system anytime he wants it. Make him comfortable and your cold backups will be a thing of the past, otherwise, get another boss!

Just my .02

Mike

Edgar Chupit wrote: 
The 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@xxxxxxxxx> 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
-- http://www.freelists.org/webpage/oracle-l

Other related posts: