RE: RMAN

Hi Ruth,

I am glad to hear that someone else has taken the same route I have. I think I ticked off the sysadmin but I really don't care :) I can blame it all on hormones. It adds another step in recovery, and I have a feeling all my rman reports won't be correct (because they want to be able to see the backup sets that have been created) but I can live with that.

You are right, the backup to disk is lightning fast compared to even the fastest write to tape. I am a bit concerned about the lag between taking the backup and writing the backup sets to tape, but it's better than waiting several hours for a backup to complete.

Have a great afternoon!
Lisa

> -----Original Message-----
> From: Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
> Sent: Thursday, April 04, 2002 10:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RMAN
>
> Lisa,
> We baclup to disk and use the OS backup to tape to put the backupsets on
> tape. Disk is much faster and the OS can do the copy to tape in the
> background whenever.
>
> And don't feel bad about 8.1.7 forever, we are stuck on 8.0.6.3 forever
> because the contractors who build our application refused to go on to 8i
> so
> we can't, ever. The contractors are gone and the boss is afraid of change.
>
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, April 04, 2002 9:38 AM
>
>
> > Hi Kimberly, we are on 8.1.7. Like I said below, we are stuck with
> Arcserve
> > (and limited to 8.1.* because of that). However, I've decided to backup
> to
> > disk and then let Arcserve grab the datasets and write them to tape. I
> was
> > able to integrate rman and Arcserve but it was soooooo slow, and since
> > neither CA nor the sysadmin could tell me what is involved with backup
> by
> > proxy, I said thanks but no thanks.
> >
> > I wish we could go to 9.x. I have a feeling it will be a while.
> >
> > Good luck and happy hunting with 9! I'm jealous.
> >
> > > -----Original Message-----
> > > From: Kimberly Smith [SMTP:ksmith2_at_myfirstlink.net]
> > > Sent: Wednesday, April 03, 2002 9:48 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: RMAN
> > >
> > > Lisa,
> > > What version of Oracle are you using? We are toying with using RMAN
> to
> > > backup our 9i databases. We are using Legato so I am figuring the
> > > integration will be pretty good. I never really felt the need to give
> up
> > > my
> > > scripts before but then again, I was always able to back up to disk or
> > > shut
> > > the database down. No longer the case. Plus, 9i RMAN offers block
> level
> > > recovery, which peaked my interest.
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, April 03, 2002 10:18 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Dave,
> > >
> > > I never said setup was easy. I agree that getting the tape software
> > > integrated can be a real pain in the side, depending on what vendor
> you
> > > use
> > > (DON'T USE CA'S ARCSERVE)
> > >
> > > As far as backup goes, this is my command for full database backup.
> Much
> > > simpler than strategies I've had to use in the past:
> > >
> > > run {
> > >
> > > allocate channel tape1 type 'sbt_tape'
> > > format '%d_%s_%p_%t.rman';
> > >
> > > backup database
> > > tag='full_db_backup'
> > > setsize 5000000;
> > >
> > > }
> > >
> > > Since I don't have the luxury of a catalog database at my disposal, I
> > > can't
> > > store scripts so my alter system archive log all statement, backup
> > > archivelogs and controlfile are separate run statements.
> > >
> > > Here's the simplest part. I have tested recovery from several
> scenarios
> > > with just the following commands:
> > >
> > > restore database;
> > > recover database;
> > >
> > > and watched rman bring back the necessary archive logs and database
> files.
> > > Now that is simple if you ask me, especially if I happen to be
> half-asleep
> > > when I need to do this.
> > >
> > >
> > > Lisa Koivu
> > > Oracle Database Baby Oven.
> > > Fairfield Resorts, Inc.
> > > 954-935-4117
> > >
> > >
> > > > -----Original Message-----
> > > > From: Dave Morgan [SMTP:dave.morgan_at_cybersurf.net]
> > > > Sent: Wednesday, April 03, 2002 12:41 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: RE: RMAN
> > > >
> > > > Hi Lisa,
> > > > RMAN easy? ROTFL
> > > >
> > > > ksh scripts, 5 minutes to adjust environment variables done
> > > >
> > > > RMAN, let see create a seperate database, set up RMAN, oh,
> then
> > > > I have to set up RMAN in the production db to protect my
> RMAN
> db
> > > >
> > > > Oh and then shall we integrate Legato or NetBackup.
> > > >
> > > > 2 days minimum.
> > > >
> > > > Having said this, remember, who needs backups? We just need
> > > > recoveries.
> > > >
> > > > I use RMAN, I just don't trust it. I have had situations
> (8.0.5)
> > > > where
> > > > I could not recover with RMAN but could with the backups
> from
> > > > scripts
> > > >
> > > > RMAN and OEM belong in the same place, the garbage
> > > >
> > > > Long live vi, ksh/sh/bash and sqlplus
> > > >
> > > > Dave
> > > >
> > > > Lisa wrote:
> > > >
> > > > >
> > > > > Gene's afraid of R-Man!
> > > > > Gene's afraid of R-Man!
> > > > >
> > > > > Gene you will not believe how simple RMAN is once you start using
> > > it...
> > > > >
> > > > --
> > > > Dave Morgan
> > > > DBA, Cybersurf
> > > > Office: 403 777 2000 ext 284
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Dave Morgan
> > > > INET: dave.morgan_at_cybersurf.net
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > San Diego, California -- Public Internet access / Mailing
> Lists
> > > > --------------------------------------------------------------------
> > > > 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.com
> > > --
> > > Author: Koivu, Lisa
> > > INET: lisa.koivu_at_efairfield.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > 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.com
> > > --
> > > Author: Kimberly Smith
> > > INET: ksmith2_at_myfirstlink.net
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > 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.com
> > --
> > Author: Koivu, Lisa
> > INET: lisa.koivu_at_efairfield.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
-- 
Author: Koivu, Lisa
  INET: lisa.koivu_at_efairfield.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).