Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cold scheduled backup script
Shutdown-Skript on Solaris 2.5 / Oracle 7.3.2
svrmgrl <<EOF
connect internal
shutdown immediate
EOF
... Backup database files
Startup-Skript
svrmgrl <<EOF
connect internal
startup
EOF
mike_andrew_at_usiva.com wrote:
> Hello all-
>
> I am beginning to become more comfortable with the UNIX operating system with
> respect to Oracle, however I still use the client machine (Windows) often to
> do database work instead of using the UNIX OS.
>
> Could anyone tell me how they, personal preference, do a cold backup nightly.
> Basically what I would like to see is a shell script, crontab job or whatever
> you have created to shut the database down at night before backup, and
> possibly starting it up again after backup is complete.
>
> I would like to run the backup at 3:00 am when I am sure no one would be using
> the database, and then start it back up again when the backup is complete.
>
> Oracle 7.3.2.3.0 & HP-UX B.10.20
>
> Thank you in advance !
> Mike
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Sep 17 1998 - 10:00:19 CDT