Re: Oracle shutdown abort on NT

Is this for an 8 installation??
If you're running Oracle7 on (DEC-ALPHA) NT4, you must also shutdown the service (oracleservice{SID}), as this holds the databaese files locked open. use a "net stop oracleservice{SID}" after the shutdown script, and a "net start......" before the startup.
I found this out the hard way! -- if you're using ntbackup.exe, check the logfile for "File in Use" errors, and make sure that none of you database files are skipped.

Will

PaulCinVT wrote:

> 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

--

ISS UNIX support
The University Of Leeds.
0113 233 5670 Received on Thu Sep 16 1999 - 03:12:24 CDT