Oracle 11i database backup

[hsbdba]

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 .

hsbdba

[Sonal1]

Hi,

You can try the command "net stop servicename" in a batch file.

e.g.

net stop OracleServiceORCL


Regards,

Sonal.

[bkrish]

Hi,

You can automate schedule startups and shutdowns and backups using a combination of "at" and "net" commands.

Hope this helps.

[ksnavin]

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]

[hnagia]

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