we just install in our compnay oracle financial 11 i our platform is windows nt , so once i want to make backup
throgh windows nt (closed backup) i have to shutdown the database the only way to do is through closing several services from windows nt , so are there any way to close this service automatically , or are there another way to mak batch file to do this job .
You can try the command "net stop servicename" in a batch file.
net stop OracleServiceORCL
You can automate schedule startups and shutdowns and backups using a combination of "at" and "net" commands.
Hope this helps.
You can creat a batch file with all net stop "service name" for the services and call this batch file in the NT scheduler..
And your backup can be scheduled thru NT backup Manager.
[Edited by ksnavin on 09-10-2001 at 02:44 PM]
ORACLE APPS DBA
be sure of :
* closing the concurrent manager through :
net stop oracleconcmgrprod
* shut down the database from the server manager at first by using a simple script OR if you are working on Windows 2000 you can adjust the service to shut down in immediate mode
* in case of using server manager , follow it up with :
net stop oracleerviceprod
* Take your backup
* start everything again by :
net start oralceserviceprod
net start oracleconcmgrprod
IT Manager For Development
Oracle Consultant - OCP
Click Here to Expand Forum to Full Width