Backup on NT

Hi everyone!

I would like to know what is the best way to backup an Oracle database on a Windows NT machine.

I have Oracle Server 7.3 on Windows NT Server 4.0 machine. I currently have 3 small databases, but they are growing. I am using a batch file that calls ocopy to copy all the database files (ctl*.ora, log*.ora, rbs*.ora, sys*.ora, tmp*.ora, usr*.ora) to another hard disk location (with the database up) and then use ntbackup to back them up to tape. I schedule this batch file using the at command.

I would (ideally) like to:
- Backup directly to tape

• Keep the backup scheduled/unattended
• Specify the database to backup and not each file of the database

I can afford to shutdown the database at night and do cold backups, if there is an unattended way to do the shutdown and startup of the database.

Any ideas/suggestion will be greatly appreaciated! Oh, and could you please send them not only to the newsgroup but also to my e-mail address?

Thank you so much!

Ana Neto
e-mail: ana.neto_at_pararede.pt Received on Thu Feb 26 1998 - 00:00:00 CST