Re: RE: B&R solutions

I use to clone our reporting databases. For a datbase about 50gig in size it takes about 2 hours on a 2 processpr AIX machine. It doens't take an extra databases to create a clone, only the clone itself. With O8i you can use the duplicate command to create a clone from an rman backup. It is very simple!

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, July 26, 2002 2:10 PM

> In Rich's case (I was working with him when his infrastructure
> was built) and in mine now, the backups largely define how
> database cloning is carried out. We are using Veritas Snaps here,
> allowing me to clone an instance with few minutes of sync time
> and a control file rebuild, much faster than using RMAN or
> anything else I have seen to build a clone. Rich's system copies
> all the files to a storage area, which then is used as the
> source of datafile copies for his cloning.
>
> In the case of RMAN, the clone requires an extra database be active,
> the storage is handled spread over several different files, i.e.
> you'll have to reconstitute the datafiles when cloning. Note, this
> is MY understanding and I may be totally off base, I don't use RMAN.
> It seems on it's face however that cloning would take longer running
> through a repository and rebuilding files than simple file copies
> through some other mechanism.
>
> My real point is, backups and clones are intimately related. If you
> don't have to clone very often and/or have a good window for doing
> so, overhead associated with how RMAN does its block level backing
> up may not be an issue. If you have to tweak to minimize every
> second of development downtime (Rich and I had to do this), another
> approach may prove better at meeting that goal. Regardless, if one
> strategy has been implemented, the whole ball of wax has to be addressed
> when considering making a change.
>
> Hope this is clearer...and would love to hear other opinions about
> this,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
>
>
>
> -----Original Message-----
> Sent: Friday, July 26, 2002 1:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> John - Can you please elaborate on your statement? We've just started
using
> RMAN and haven't yet used it to refresh the development environment, so I
am
> curious how your statement may apply to me. Thanks.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Thursday, July 25, 2002 3:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> There's also the little matter of the dev refresh strategy being wedded to
> the backup strategy. Moving
> generally means ripping out the best part of the infrastructure. :)
>
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
>
> -----Original Message-----
> Sent: Thursday, July 25, 2002 4:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> amen! and remember...what was it called...EBU? I wanted to make sure
RMAN
> was here to stay before moving to it. Well it looks like it's here to
stay,
> I just don't want to change a good backup strategy that I am comfortable
> with.
>
> - Rich
>
> -----Original Message-----
>
> Sent: Thursday, July 25, 2002 3:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I kinfa hate to admit it, but I'm one of those who has not embrased RMAN.
> More
> out of lack of time to investigate than anything else, but to make real
use
> of
> it here I need to intergrate it with OmniBack, which requires a database
> relink.
> And getting the databases away from the end users long enough is a real
> pain in
> the $%#.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Mercadante; Thomas F" <NDATFM_at_labor.state.ny.us>
> Date: 7/25/2002 10:13 AM
>
> I agree with Ruth (using Rman since 805). Robust, stable and easy to use.
> And Free!
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Thursday, July 25, 2002 12:54 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have used rman since O804 and it's just gotten better and better. I
have
>
> never tried anything else. It's free so the State likes that.
>
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, July 25, 2002 11:08 AM
>
>
> Can anyone advise what the most popular solutions are being used nowadays
> for database backup and recovery. I would imagine that RMAN is a
> cornerstone of most, if not all solutions. Anyone out there using Galaxy
> CommVault?.
>
> Would seasoned folk be so kind as to state what solutions (Oralce and or
3rd
>
> party) they have found to be a robust tried and tested solution.
>
> -------------------------
> Sean O' Neill
> Organon (Ireland) Ltd.
> [subscribed: digest mode]
> --------------------------------------------------------------------
> This message, including attached files, may contain confidential
> information and is intended only for the use by the individual
> and/or the entity to which it is addressed. Any unauthorized use,
> dissemination of, or copying of the information contained herein is
> not allowed and may lead to irreparable harm and damage for which
> you may be held liable. If you receive this message in error or if
> it is intended for someone else please notify the sender by
> returning this e-mail immediately and delete the message.
> --------------------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> <http://www.orafaq.com>
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> 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
> <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
> <http://www.orafaq.com>
> --
> Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.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
> <http://www.orafaq.com>
> --
> Author:
> INET: dgoulet_at_vicr.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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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: John Weatherman
> INET: john.weatherman_at_replacements.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).