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: RE: B&R solutions

RE: RE: B&R solutions

From: John Weatherman <john.weatherman_at_replacements.com>
Date: Fri, 26 Jul 2002 10:10:48 -0800
Message-ID: <F001.004A3B39.20020726101048@fatcity.com>


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.

-----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). Received on Fri Jul 26 2002 - 13:10:48 CDT

Original text of this message

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