Re: backup Oracle 9i on Win 2K server

"Andrew Tompkins" <andrew.tompkins_at_jjmackay.ca> wrote in message news:<eKMe8.42$7j5.16742_at_sapphire.mtt.net>...
> Ok. All I am concerned about is the cold backup. We don't have a
> production database (it is only for development testing) so backup of every
> single transaction is not necessary. If there is a better way to shut down
> the instances then what is it?? Can it be done automatically??
>
> Thanks for all the replies.
>
> Andrew

I wrote a simple script to do a cold backup on Windows NT (works for 8i and 9i). You can download it here -
http://www.dbaquest.com/modules.php?op=modload&name=News&file=article&sid=13&mode=thread&order=0

Schedule the .bat file using the Scheduled Tasks wizard to automate your cold backups. The script itself is pretty self-explanatory.

Murali
http://www.dbaquest.com/ Received on Tue Feb 26 2002 - 14:15:16 CST