Re: Automating NT Backup with archivelog on (hot)

From: <sun_haibo_at_yahoo.com>
Date: Thu, 10 Dec 1998 10:27:10 GMT
Message-ID: <74o7lu$fn$1@nnrp1.dejanews.com>

Hi,
AT command can set up schedule jobs to run a batch. In batch file, following commands are added for HOT incremental backup OCOPY73 db_file(archive log files,control file and redo log files) new_file

For COLD full backup, add
net stop OracleTNSListener
net stop OracleStartSID
net stop OracleServiceSID
copy all database files to ...
net start OracleServiceSID
net start OracleStartSID
net start OracleTNSListener

Regards

Hai Bo

In article <366f13cd.113752777_at_news.conxion.com>, Peter_at_Kellner.com (Peter Kellner) wrote:
> Hi,
>
> I'd like to automate backing up an NT server running oracle 7.3.
> Right now, it is a big pain because of all the manual steps. I want
> to have one script that does an incremental with the system HOT,
> and another script that shuts the database down, does a full backup,
> then starts it again.
>
> Any ideas or places I can find such a thing. I want to make sure that
> error status are checked for things like deleting transaction logs.
>
> Thanks for any help
>
> Peter_at_kellner.com
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 10 1998 - 04:27:10 CST