In order to get a successful backup using most tape software, users must shutdown the Oracle database before beginning the backup. Some tape software can interfere with Oracle by locking data files and this can cause Oracle to shutdown abnormally.

The attached files can be loaded into the c:\datautil folder and called from the tape software to shutdown Oracle before a backup (dbasedwn.bat) and to startup Oracle after the backup (dbaseup.bat).

The files may need to be modified if the following is not true:
1) Customer is not using Oracle v9.2.0.1.0
2) Password for SYS user is not CMAX
3) Files are not loaded in the C:\DataUtil folder

To test the files, do the following:
A) Press Start - Run and enter 'CMD' to get a command window.
B) Make sure that you are in the root directory of the C: drive. Issue these commands to be sure:
C:
CD\

Note: Do NOT test the batch files from the directory where they are located. It is important to test the startup and shutdown from a different directory because the Scheduler or the tape software may start the batch files from a different directory too.

C) First, test the shutdown by typing:
C:\DATAUTIL\DBASEDWN

The messages should indicate that the services were stopped and the Oracle database was shutdown. There should be no errors or warnings.

D) Second, test the startup by typing:
C:\DATAUTIL\DBASEUP

The messages should indicate that the database and the services were started successfully. There should be no errors or warnings.