DOS BATCH SCRIPT TO SHUTDOWN AND START ORACLE FOR WINDOWS

I am in the process of moving my Oracle database from Tru64 Unix to Windows Server 2000. I will be backing up the database using Veritas software. The software will not backup the database unless it is shutdown. I have created scripts in UNIX to do this but I can not seem to get a script to work from DOS.

If anyone has created a batch script to run as a scheduled job in Windows I would appreciate any assistance on this.

 

Dennis Arrigan

arriganberkeley.edu

 

Hi Dennis,

 

We run our Oracle on UNIX, but a sqlplus script as sysdba run under the appropriate user (not sure what that is in the Windows world) to do a shutdown doesn̵7;t work? ; What about a command-prompt net stop/net start?  I assume the return code checking is robust from those commands, but that’;s something I certainly wouldnR17;t take on blind faith.

 

If you’re running 10g, why not go with rman, so you can do backups on a live system?  It’s much improved over previous releases.  The backup software could just skip the live data files in that case. ; You’d also get the benefits of archiving logs for point in time recovery, which it sounds like you might not currently have. ; This will also give you a host of other benefits you won’t get from a cold backup.

 

Paul