Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Urgent! Backup Software on NT for a huge Oracle database

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

From: Chris Weiss <weisschr_at_pilot.msu.edu>
Date: Wed, 11 Aug 1999 16:47:04 -0400
Message-ID: <7osnh8$5tq$1@msunews.cl.msu.edu>


Did you put the drives in separate drive pools and the tapes in separate media pools? If not, BE gets confused.

Chris

Dong Tang <tangd_at_ctcdist.com> wrote in message news:pLjs3.2763$Qn4.294950_at_ptah.visi.com...
> Hi:
>
>
> One of the problems I am with Backup Exec is it have problems with two
> drives. In order to backup whole database as quick as possible. I set up
> two jobs, each backups a half database. I let those two jobs runing
> simultaneously on the two drives, each job runs on one drive. However,
> whenever one job finished, the other job aborted automatically!
>
> And here is other horrible storaty, I once used quick ease to ease several
> tapes in Library at same time. It suppose to ease those tapes one by one.
> BE easeg all those drives, PLUS other tape with files I need! At first, I
> think I made mistake ease the wrong tape, but after I checked the log
file,
> I was convincd that I didn't any thing wrong.
> BE may work with single tape drive, but it just doesn't work well with
> automatic loader and tape library.
>
> Dong Tang
> Chris Weiss wrote in message <7osb0g$4gp$1_at_msunews.cl.msu.edu>...
> >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 - 15:47:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US