Anyone look at the 10g new features? Is this one of
things Oracle is claiming they can eliminate with 10g? So you dont need this
license?
----- Original Message -----
Sent: Friday, January 09, 2004 8:29
PM
Subject: Re: Backups in a DW
Environment
The license is for the
software that interfaces Veritas NetBackup to RMAN.
RMAN has an API and NBU has an API. The
intersection of the 2 will set
you
back about $1500 US IIRC.
Jared
|
| "Ryan" <ryan.gaffuri@cox.net>
Sent by: ml-errors@fatcity.com
01/09/2004 04:39 PM
Please respond to ORACLE-L
|
To:
Multiple recipients of list ORACLE-L
<ORACLE-L@fatcity.com>
cc:
Subject: Re: Backups in a DW
Environment |
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@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@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@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@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@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@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@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@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@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@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@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).
Received on Fri Jan 09 2004 - 19:49:26 CST
