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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backups in a DW Environment

RE: Backups in a DW Environment

From: Jared Still <jkstill_at_cybcon.com>
Date: Sun, 11 Jan 2004 11:14:27 -0800
Message-ID: <F001.005DC69A.20040111111427@fatcity.com>


... with the caveat of somewhat complicating the recovery process.

On Sat, 2004-01-10 at 13:49, DENNIS WILLIAMS wrote:
> Ryan - I don't see where you received a direct answer to this question. To
> use RMAN to back up to tape you must license what Oracle terms a MML (media
> management library). However, you can use RMAN to back up to disk without
> any additional purchase. My sys admin evaluated the cost of the MML piece
> from Veritas for our size of server and said the additional disk area was
> cheaper, so we use RMAN to disk.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Friday, January 09, 2004 6:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I never heard about the required license from veritas and legato. Can
> someone else confirm that this is necessary? They actually charge you more
> money to do use another product with veriftas and legato?
>
> What is a 'BCV'?
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, January 09, 2004 7:19 PM
>
>
> > Let's assume RMAN is not an option since we don't have
> > a license or busget to use a third party backup tool
> > like Legato or Veritas with RMAN (used in a previous
> > life with Legato NetWorker. Loved it!!)
> >
> > So now I'm left with archive log mode. Archive logs
> > backed up nightly and a full backup once a week. I
> > have to set aside at least as much disk space for the
> > data files as the size of the physical db which will
> > later be copied to tape. Plus, I also need disk space
> > for my BCVs'. I can't have both (budgetry
> > constraints). I'm leaning towards BCV's. Wouldn't it
> > be just as quick to restore the entire BCV as to do an
> > Oracle recovery from tape?
> >
> > Also Gene, you mention that while loading data, you
> > turn off archiving. So if you lost that dbf during a
> > load, how would you recover the db? Restore the dbf,
> > apply the logs and restart the load, right?
> >
> > In the same scenario in my environment I'd just
> > restore the entire BCV set and re-start the load. Not
> > an expert on EMC's BCV technology but my sysadmin says
> > it can be done and yes, I'll test before I sign off on
> > it.
> >
> > True, I'd be nice to have archive logging aswell. But
> > is it a necassity or have we all been programmed into
> > believing that "ALL PRODUCTION DATABASES MUST BE IN
> > ARCHIVE LOG REGARDLESS". Should we not be progressing
> > beyond this like we did with hit ratios and one large
> > extents etc...?
> >
> > mohammed - jumping into flame proof suit
> >
> > --- Gene Sais <Gsais_at_co.palm-beach.fl.us> wrote:
> > > I put all databases in archive mode, i.e. dev, test,
> > > and production. I
> > > can use test db's to test backup/recovery
> > > scenario's. The only time
> > > they are not in archive mode is when I am doing a
> > > major load
> > > (import,sqlload,etc). After I am done loading data,
> > > I put them back
> > > into archive mode. What does it cost you, a few
> > > archives? Ha, well
> > > worth it :).
> > > Gene
> > > PS. On a side note, Robert Freeman, your book is a
> > > must have using
> > > RMAN. Thanks for writing it!
> > >
> > > >>> Mark.Bobak_at_il.proquest.com 01/09/04 04:54PM >>>
> > > My personal opinion is all production databases
> > > should be in
> > > archivelog
> > > mode. Period. End of story.
> > >
> > > Less down time, more recovery options....it's all
> > > good.
> > >
> > > Having said that, given a specific business case,
> > > with a specific set
> > > of
> > > requirements, one could argue for noarchivelog mode,
> > > and you might
> > > even
> > > convince me...but I doubt it...;-)
> > >
> > > -Mark
> > >
> > > Mark J. Bobak
> > > Oracle DBA
> > > ProQuest Company
> > > Ann Arbor, MI
> > > "Imagination was given to man to compensate him for
> > > what he is not,
> > > and
> > > a sense of humor was provided to console him for
> > > what he is."
> > > --Unknown
> > >
> > >
> > > -----Original Message-----
> > > Sent: Friday, January 09, 2004 4:25 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Have a question on backups in a DW environment.
> > >
> > > Our DW is somewhat small at the moment but projected
> > > to grow. I seem to be having a hard time trying to
> > > convince the sys admin that I don't want archive
> > > logging turned on. To me, it does'nt make much
> > > sense.
> > >
> > > He's proposed using EMC BCV's which I've agreed to
> > > (and also sounds like a good idea) but also wants to
> > > turn on archiving. My thinking is why turn on
> > > archiving if I can restore my DB from last night's
> > > BCV's and then bring it up to date by re-loading any
> > > data that was loaded after the BCV split.
> > >
> > > Our system is not 24x7 so we can shutdown before the
> > > BCV split. Also, it's not directly accessed by
> > > users
> > > for ad-hoc queries. Automated processes access the
> > > database and build cubes using Cognos tools. Users
> > > access these and not the DB directly.
> > >
> > > So, again I don't see the need for archive logging.
> > >
> > > Any thoughts?
> > >
> > > mohammed
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! Hotjobs: Enter the "Signing Bonus"
> > > Sweepstakes
> > > http://hotjobs.sweepstakes.yahoo.com/signingbonus
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.net
> > > --
> > > Author: mkb
> > > INET: mkb125_at_yahoo.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: Bobak, Mark
> > > INET: Mark.Bobak_at_il.proquest.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).
> > >
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> > http://hotjobs.sweepstakes.yahoo.com/signingbonus
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: mkb
> > INET: mkb125_at_yahoo.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: Ryan
> INET: ryan.gaffuri_at_cox.net
>
> 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: 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).
Received on Sun Jan 11 2004 - 13:14:27 CST

Original text of this message

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