Re: Hotbackup's, Veritas Oracle agent, Interested in Backing up strategies!

Michael Nhan wrote:

> Demandred wrote:
>
> > I have a couple of Oracle Application's Instance's. The versions that
> > I'm running is 11.5.4 which comes with Oracle 8i version 8.1.7.1.0. I'm
> > currently trying to come up with a backup strategy that will work for
> > me.
> >
> > My goals are to have a oracle database backed up nightly without
> > shutting it off. I need a full backup everyday.
> >
> > Information that may prove useful I'm running Solaris 2.6.
> >
> > I'm really just curious as too what everyone one else uses to do this
> > backup?
> >
> > Thanks,
>
> Hi,
>
> We use netbackup with the oracle agent. Using a RMAN repository and two
> shell script I get nightly backup of the database. One shell script
> handles level0 and the other level2 incremental to make things clean.
> Backing up to a single tape/disk when the database is small is do-able, but
> when your database exceeds 50gigs, that gets to be rather difficult. It
> really depends on the size of the database you are dealing with and how
> much extra disk or storage you have available to you outside the database
> to play with. Backing up to disk is the fastest, but requires you have the
> space and hardware to handle it. Just my 2 cents.
>
> Michael

Michael,

Lets see my database is no where near 50gigs in size. It's more like 20 gigs and the tape I have to back it up with can take 150gigs so there is no problem there. I think the ideal way for me to backup would be to have an extra drive that I quickly dump the data to and then I would have the tape backup that dump. Now here is my problem. I have veritas netbackup with the agent I just don't have a clue as to how to install it. Right now it would be ok to shutdown the database at night and quickly do a copy to a empty drive and then have the tape back it up. Here is where my lack of oracle dba knownledge comes in. I have a plan I just don't know how to implement it. How do I write a shell script that goes out there and shutdown the database??? Are there sql scripts out there that shutdown/startup the database for me? If so I guess I could use one of those to shutdown the db and then run a simple copy. After the copy is done I would have to run another sql script to bring it up. Then the tape comes in.

Other problems I face is. What if I have archiving setup? Do I have to back those up too? Anyone have seen a good white paper on this that I could read so that I could get my feet wet.

Thanks in advance,cop Received on Tue Aug 07 2001 - 16:10:04 CDT