RE: AW: RMAN Backup to tape or disk (SAN) ???

I was able to accomplish this test with tape backups - OS and RMAN database. I put my RMAN on a centralized backup server. It is small and if I have multiple Oracle versions (binaries) then I have to have the separate binaries on that centralized management server for the correct catalog (want to go to one version .....but....COTS). Each night after all RMAN backups using MML to tape, the centralized backup server is brought down along with RMAN cleanly. The binaries and RMAN are copied to tape.

On recovery (I did this from Solaris 2.8 to 2.8 and 2.6 (w/ relink)) series of scripts to copy centralized server onto new host.

>From there it is simply a matter of using RMAN and tape library to recovery
all of our databases for this enterprise.

Worked, was fast and reliable. I understand that there maybe issues with upgrades on Oracle binaries on the disaster recovery platform after this approach. However, not a major issue because how many upgrades would you be doing on a disaster recovery platform anyway.

Everything pre-scripted and tested. Also, can quickly have the tapes cloned and offsite pretty far away. We after all leave in the capital city of Florida where little brother Bush also lives.

Oracle OCP DBA

-----Original Message-----
Sent: Thursday, May 08, 2003 1:22 PM
To: Multiple recipients of list ORACLE-L

Jared

   Veritas prices this by the size of the server. Our sys admin recalls a quote of around 8K, but that was a couple of years ago. And we are using NFS mounts as disk storage, so that is much cheaper than SAN. Not being familiar with an MML, that seemed a little more intimidating.

   The other factor was disaster recovery. Our management gave us the criteria "assume all you have is your offsite tape, now verify that you could go to a new server, load what you need to load and then recover the database." We were able to accomplish that with RMAN having written to disk. Maybe that is even easier with an MML writing to a SAN, I wouldn't know.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, May 07, 2003 1:37 PM
To: Multiple recipients of list ORACLE-L

I wonder why so much?

We're on the West Coast of the U.S. and we're paying about $2500 US for those licences.

Jared

On Wednesday 07 May 2003 05:52, Daiminger, Helmut wrote:
> Jared,
>
> Veritas told us that an Oracle Agent is about 8000 Euros (1 Euro = $1.10
> US) and we would need nine of them. This would buy us quite a few disks.
>
> We are thinking about making the "backup disk" so big that it can hold at
> least two weeks worth of backups. Anything older will be moved to tape.
> Does that sound reasonable?
>
> Thanks,
> Helmut
>
> > -----Ursprüngliche Nachricht-----
> > Von: Jared Still [mailto:jkstill_at_cybcon.com]
> > Gesendet: Mittwoch, 7. Mai 2003 02:21
> > An: ORACLE-L_at_fatcity.com; Daiminger, Helmut
> > Betreff: Re: RMAN Backup to tape or disk (SAN) ???
> >
> >
> >
> > Helmut,
> >
> > What amount of $$ is 'horribly expensive"?
> >
> > The Oracle Agent for Veritas is about $2500 per
> > server if I recall correctly. They don't give it away,
> > but it isn't *that* much.
> >
> > Someone else said that there SA could buy a lot of
> > disk for the price of the agent. In a SAN, $2500 will
> > generally buy you about 2.5 disks.
> >
> > Personally, I dislike backing up to disk. That creates
> > a logical disconnect between RMAN and the Veritas
> > backup catalog.
> >
> > ie. You can't then just tell RMAN to restore your database
> > to anytime other than what is on the backup disks. If the
> > backup files are lost/damaged, you must be certain to restore
> > all of the files needed Oracle files from tape to disk, then
> > do your recovery.
> >
> > Jared
> >
> > On Tuesday 06 May 2003 05:25, Daiminger, Helmut wrote:
> > > Hi!
> > >
> > > We are about to redesign our backup environment. All Oracle Backups
> > > (8i,
> > > 9i) are done with RMAN. Now we are unsure whether to have
> >
> > RMAN backup to
> >
> > > tape or to a specific area on our SAN.
> > >
> > > Backing up to the SAN (i.e. disk) is an option, since you
> >
> > don't need
> >
> > > Veritas NetBackup Oracle Agents (which are horribly expensive). We
> > > would have RMAN write the backups to disk and then move
> >
> > those backups
> >
> > > to tape. The disk will be about the size to hold two weeks worth of
> > > RMAN backups.
> > >
> > > Would this make sense? Or is it preferable to backup to tape, no
> > > matter what?
> > >
> > > This is 8i & 9i on Sun Solaris.
> > >
> > > Thanks,
> > > Helmut
> >
> > ----------------------------------------
> > Content-Type: text/html; name="Attachment: 1"
> > Content-Transfer-Encoding: quoted-printable
> > Content-Description:
> > ----------------------------------------

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Paula_Stankus_at_doh.state.fl.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).