Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Scheduling Backups on NT

Scheduling Backups on NT

From: Ian Sparkes <sparkes_at_sprintmail.com>
Date: 1997/05/01
Message-ID: <01bc55f6$15069540$628285ce@primenet.primenet.com>#1/1

I've recently been attempting to schedule an off-line backup on NT 3.5.1 with a 7.3 database and have been running into some unexpected problems.

When the shutdown script run the backup.bat script exited and never gets to the backup statement. Also the startup script starts the database up and then it immediately shuts down.

I tried replacing the shutdown/startup scripts with oradim73 but a) It seems to asynchronously send a shutdown to the service, therefore there is no assurance that the Db is down by the time ntbackup runs and b) the startup with oradim73 was ignored.

I haven't had a chance to research this yet but it seems like real strange behavior and either there is a significant problem or I've done something stupid.

Anybody have an idea what is going on ?

I used the .bat/.sql files below

shutdown.sql

	connect internal
	shutdown immediate
	startup restrict
	shutdown

startup.sql
	connect internal
	startup

shutdown.bat
	svrmgr23 shutdown

startup.bat
	svrmgr23 @startup

backup.bat
	shutdown
	ntbackup .....
	startup
Received on Thu May 01 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US