Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how do I start SVRMGRL and do shutdown immediate???
MannyMac wrote in message <19990526002016.01642.00006382_at_ng-cg1.aol.com>...
>I would like to know how to start the srvmgrl and do a shutdown immediate
of
>the database for backup purposes... is this possible???
>how can I put this into a shell script or a crontab job?????
Try this as a shutdown script:
--
svrmgrl <<EOF
connect internal;
shutdown immediate;
exit;
EOF
--
Type crontab -e to edit the cron table and add the script to it.
If you want to automate backups, put as much effort into error checking and trapping in your UNIX scripts as possible. It's worth the effort - nothing starts a bad day off like walking into the office, having a backup lying belly-up and a database that does not know whether it is suppose to be down or not. :-)
regards,
Billy
Received on Wed May 26 1999 - 04:37:33 CDT