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. [EMAIL PROTECTED] -----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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).