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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Backups with Oracle 7.3 and Windows NT 4.0 ?

Re: Backups with Oracle 7.3 and Windows NT 4.0 ?

From: allen lucas <alucus_at_concentric.net>
Date: 29 Jul 1998 06:29:33 PDT
Message-ID: <35BF23F6.81E@concentric.net>


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.net

===================================================================
Received on Wed Jul 29 1998 - 08:29:33 CDT

Original text of this message

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