Hi Ryan,
Not for RMAN. I meant a license for Veritas or
Legato.
See Mladen's reply re: BCV (basically EMC takes a
snapshot of the mount points onto corresponding mount
points i.e. a 1-to-1 mapping for each mount point onto
a BCV mount point)
Hope that clears up the confusion.
mohammed
- Ryan <ryan.gaffuri_at_cox.net> wrote:
> 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
>
=== message truncated ===
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).
Received on Fri Jan 09 2004 - 19:29:33 CST
