Oracle startup/shutdown scripts for UNIX

[sunguru99]

I need to be able to do a cold backup of an Oracle database with a script. In order to do this, I need to shutdown/startup the Database automatically with a script. Here is a list of the manual commands to shutdown and startup the database:

su - applmgr

cd /usr/local/bin

. stopmanagers.sh shnp

su - oracle

svrmgrl

connect internal

shutdown immediate


-----------------------------------------------------------


su - applmgr

cd /usr/local/bin

. startmanagers.sh chnp

su - oracle

svrmgrl

connect internal

startup

Could someone help me with this?

 

[dbtoo2001]

It probably took more typing to input your question than it would have been to go to google.com and request information on 'oracle backup unix script', which, on the first page of returned links yields a fairly extensive script:

http://www.dbaclick.com/modules.php?op=modload&name=News&file=index&catid=1

I cannot vouch for whether or not the script works, it would certainly most likely need to be modified for your environment, but then again, so would anything provided from this forum. (Dave -

 

[alexhu]

Oracle provides the command 'dbstart' and 'dbshut' to start and close all databases listed in /etc/oratab - might be worth using these ?

Alex