Re: Urgent! Backup Software on NT for a huge Oracle database

A couple of suggestions:

1. Upgrade to Oracle 8.0.5. 8.0.4 is a little buggy.
2. Reinstall backup exec.
3. Upgrade to SP5 for NT 4.0.
4. Get the latest drivers for your tape system.
5. Export your database in chunks - critical data first, and backup the export files only.

I use the version of Backup Exec you are describing with a single DLT tape drive on a Dell Poweredge 6300, and it works fine.

Backup Exec will complain and generate errors if your Oracle instance is still up. If there is any activity on your database anywhere, including an open session, backup exec may bomb. Kick everyone off, and down your database if you need a complete backup.

You can use the "AT" command in NT to run a script to clear all open sessions, to perform exports, and to down your database. Oracle 8.0.x on NT has a command line version of SQL*PLUS that runs well. I have used AT scripts to control my backup, and they work as well as cron job of similar complexity.

My suggestions are not nearly as good as a full cold backup of your Oracle instance, but it will allow you to successfully rebuild your database.

Good luck.

Christopher Weiss
Professional Services Division
Compuware Corporation

Dong Tang <tangd_at_ctcdist.com> wrote in message news:yXhs3.2728$Qn4.291155_at_ptah.visi.com...
> Hi:
>
> Our company have a 200+GB mission critical Oracle 8.0.4 database running
on
> NT4.0 SP3. Don't ask me why run that size database on NT, it is beyond me.
> The hardwares are Compaq Proliant 5000 with 4 pentiumpro processors, 3
RAIDs
> (108 GB, 108GB and 16GB), two 35/70 DLT tape drives with 15 tape library
> with autoloader.
> Past year we have been using Seagate Backup Exec 7.0 to backup the
database.
> This thing is even worse than NT OS, cause us huge problems. I contact
> their technical support, they don't have clue either.
>
> Does anybody know any backup software can run on NT, can work with DLT
> autoloader and tape library and use script to schedule and fire up backup
> jobs? Please help, we have not backuped the database for more than one
> month! Basically, I am waiting for disaster now .
>
> Please email me at tangd_at_ctcdisct.com
>
>
>
> Thanks ahead.
>
> Dong Tang
>
>
>
>
Received on Wed Aug 11 1999 - 12:13:17 CDT