RE: DB copying : Attack of the Clones!

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:RGesler_at_lexington.com]
> 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:kirti.deshpande_at_verizon.com>]
> 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: kirti.deshpande_at_verizon.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).