Re: Oracle shutdown abort on NT

We leave our servers up 24 hours a day, but are able to do clean cold backups in the wee hours with the following steps...

1.create shutdown script
Shutdown.sql
Connect internal/<password>
Shutdown immediate
Startup restrict
Shutdown normal
Exit

2.create startup script
Startup.sql
Connect internal/<password>
Startup
Exit

3.create batch file
Orabak.bat
C:\orant\bin\svrmgr30.exe @<directory stuff>shutdown.sql Backup c:\orant\database\*.* <target for backup> C:\orant\bin\svrmgr30.exe @<directory stuff>startup.sql

4.schedule batch file
command prompt> at 02:00 c:\temp\orabak.bat

Paul in VT Received on Tue Sep 14 1999 - 11:17:32 CDT