Re: DB copying : Attack of the Clones!

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" <ORACLE-L_at_fatcity.com> 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: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).

-- 
Please see the official ORACLE-L FAQ: 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).