Re: Oracle Backups on NT platform ??
Date: 1996/03/24
Message-ID: <4j44ci$mce_at_news.computek.net>#1/1
The Scheduler is a tool available in NT which can be used to run scheduled jobs. The tool is available with the NT resource kit.
To perform a cold backup you could shutdown the database by running a batch file at a scheduled time, then use another batch file to bring the databases back up. This works with SQLDBA. You may be able to use NT's backup tool to perform the backup at the scheduled time. To perform a hot backup you could use the OCOPY tool along with a batch file. Hope this helps.
Dale Underwood <dale_at_fox.nstn.ca> wrote:
>Hi Oracle Gurus
>Can someone please tell me how to do scheduled back-ups (ie shutdown
>database, cold backup, restart database for Oracle 7.1.3) on Windows NT
>platform?? Also, how do you schedule hot back-ups???
>I am use to Unix environment, shell scripts and cron. I am totally
>lost in an NT environment for these "basic" DBA functions.
>BTW - We are using Oracle Server Manager and would like to implement
>the solution with Oracle Server Manager instead of SQL*DBA (so that
>it will still work once Oracle discontinues SQL*DBA).
>TIA - Babette Dale Underwood (dale_at_fox.nstn.ca)
Received on Sun Mar 24 1996 - 00:00:00 CET