Re: Automating NT Backup with archivelog on (hot)

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_at_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_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 Sat Dec 12 1998 - 20:13:58 CST