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

From: Juhan Kundla <juhan_at_ensib.ee>
Date: Fri, 13 Aug 1999 16:51:11 +0300
Message-ID: <37B422CF.FAABE21C@ensib.ee>

I'm using Seagate Backup Exec with one tape drive in our environment too and so far had no problems with it. I don't use the AT to schedule jobs, I use backup exec scheduling. I have 2 batch files (one to run before and one after backup job -- can be easily configured inside Backup Exec) to take down and start up db and execute some other SQL and OS commands. Of course, it is possible to make backups without any special software, just write a batch file like:

---

svrmgr30 command=@script1.sql
ntbackup backup <filename> [<filename>] [some other parameters] svrmgr30 command=@script2.sql

---

and use AT to schedule it. I don't know, how it works with autoloaders.

Chris Weiss wrote:
>
> 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
> >
> >
> >
> >

--
Ilusat suve...

     \  |  /
      \ | /
 -----(   )-----
      / | \
     /  |  \

...ja päikest :)

Juku Received on Fri Aug 13 1999 - 08:51:11 CDT