Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Backups with Oracle 7.3 and Windows NT 4.0 ?
Easy.
Write a .bat script which calls svrmgr with a attached .sql file. The sql file will contain all the sql scripts to shut the DB down for cold, vary the datafiles offline for hot, and copy all the files to a coldback or hotback directory.
The .bat file should be kicked off daily for the hot backups and another at job will be kicked off weekly for the cold backups.
I do this now with NT and Oracle 7.2 & 7.3.
If you are unfamiliar with the AT command in NT, simply go to the cmd prompt and enter 'AT HELP'.
--
\\||// Indecision is the key to flexibility / \ []--[] Allen Lucas @ /\ @ Chicago Bridge & Iron {----} Plainfield, Il 60544 ^^ alucus_at_concentric.netReceived on Wed Jul 29 1998 - 08:29:33 CDT
===================================================================