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" <[EMAIL PROTECTED]> 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. > [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). -- Please see the official ORACLE-L FAQ: 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).
