Xref: alice comp.databases.oracle.server:35809
Path: alice!news-feed.fnsi.net!news.he.net!pushkin.conxion.com!nntp.conxion.net.POSTED!not-for-mail
From: Peter@Kellner.com (Peter Kellner)
Newsgroups: comp.databases.oracle.server
Subject: Re: Automating NT Backup with archivelog on (hot)
Message-ID: <367322c1.13670396@news.conxion.com>
References: <366f13cd.113752777@news.conxion.com> <74o7lu$fn$1@nnrp1.dejanews.com>
X-Newsreader: Forte Agent 1.5/32.451
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 43
Date: Sun, 13 Dec 1998 02:13:58 GMT
NNTP-Posting-Date: Sat, 12 Dec 1998 18:13:58 PST

Doesn't the net stop OracleServiceSID, etc, do the same as
a "shutdown abort".  If so, does that guarantee the database
will be able to be started up again without database recovery?
I thought that it did not.  That the only guarantee was after doing
a "shutdown immediate" or "shutdown".

Please let me know.  This is very important to me.


On Thu, 10 Dec 1998 10:27:10 GMT, sun_haibo@yahoo.com wrote:

>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@news.conxion.com>,
>  Peter@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@kellner.com
>>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own