Re: database could not be started

Just 1 opinion... the exact circumstances you describe are a good reason to do a shutdown abort.

I would say it is probably always better to do a shutdown abort instead of killing the processes.

You should always try the shutdown immediate first, but do a shutdown abort after whatever time seems appropriate for your experience with shutdown immediates.

On Unix type systems, we put the shutdown immediate in the background (easy enough with the "&" on the end of the command) and then sleep 5 minutes in the script.

If the immediate has not shutdown the database in 5 minutes (doing a simple "ps" command in the script to check on the background process), then we do a shutdown abort.

Have never had a problem with a cold/offline backup where the database was not shutdown .

Note: Make sure you are backing up ALL files , especially the REDO logs for an offline/cold backup - and especially if a shutdown abort is ever issued.

-- 
"yls177" <yls177_at_hotmail.com> wrote in message
news:c06e4d68.0308081625.27d7cd45_at_posting.google.com...


> this is what actually happens

> 1) we had scripts to shutdown/startup the database for offline backup

> in our crontab entries

> 2) and these scripts had been working fine.

> 3) but recently, there had been 2 times when the scripts are not

> working

> 4) scenario: couldnt startup database therefore go and analyze

> 5) found that the shutdown script did not shutdown the database. Cos

> going into svrmgrl, and doing a startup says that "the oracle instance

> is still running"

> 5.1) do a ps -ef | grep ora and indeed saw all these oracle processes

> including the shutdown script entry.

> 5.2) going back to svrmgrl, did a shutdown immediate. still same

> result in 5.1

> 5.3) colleague did a shutdown abort and it works.

>

> my questions

>

> 1)is that isnt it dangerous to do a shutdown abort. actually, i was

> thinking about killing all the orace processes. so which is more

> advisable?

>

> 2) what are the valid reasons doing a shutdown abort.

>

> thanks