Re: Oracle shutdown abort on NT

If you are shutting down the instance for backups, it seems you are not actually running 24 hours a day.

In any case, an immediate shutdown is a clean shutdown. You don't have to start back up and shutdown normal. If you choose to shutdown abort (much faster), you will want to startup restrict and shutdown immediate or normal before taking the cold backups.

--
Jeremiah Wilton

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
Received on Tue Sep 14 1999 - 12:47:49 CDT