The good thing with using rman online backups is no down time for production. I clone a 50 gig database in about an hour and a half. I am getting the cites ready as I write this.
Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 19, 2002 4:34 PM > Currently it is taking about 3-4 hours via cold backups. All I could get > from the Damagers in the conf call yesterday was that current time is not > acceptable. They are doing this over the week-end for 5 of the databases in > a staggered fashion (1-2 hour delay), but with 9 more databases (and rather > large than these 5), there aren't enough hours in the week-end to support > this as well as routine batch processing. Today, I found out that IT > Damagers want to present all possible solutions and the COSTS to the User > Dept Damagers who will pay for the solution. Will expensive solution force > them to continue current method or use hot backup (or RMAN backup)? I am > hoping it will. In the long run, they will have to consider subsets of data, > as the databases will most likely double in sizes within a couple of years > (since we do not like to purge anything). > > Regards, > - Kirti > > > -----Original Message----- > > From: Gesler, Rich [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, July 19, 2002 2:35 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: DB copying : Attack of the Clones! > > > > What is an acceptable time frame. I figure 100G to be around 3 hrs. Is > > that not an acceptable service level? Also, what will the frequecy of the > > refreshes be? 14 databases all at once would be overwhelming but could a > > staggered refresh schedule be agreed upon? (monthly?) I have found that > > there is a fine line between "keeping data fresh" and "overlaying > > development projects" requires good communication and published service > > levels. Part of the negotiation should be that ability to do a clone > > during working hours if possible. At one point we (staff DBA's) got stuck > > doing off-hour refreshes to keep a pool of developers (hourly contract) > > from sitting on there hands. > > > > Rich > > > > > > -----Original Message----- > > From: Deshpande, Kirti [ <mailto:[EMAIL PROTECTED]>] > > Sent: Friday, July 19, 2002 2:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: DB copying : Attack of the Clones! > > > > > > Rich, > > I was informed that required disks/filesystems for the clone databases is > > > > not a problem. Hot backup is being suggested but the issue is to reduce > > 'cloning' time. > > I think we also have the out-of-band network connectivity between these > > servers. > > > > Thanks, > > > > - Kirti > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > 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).
