Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB copying : Attack of the Clones!

Re: DB copying : Attack of the Clones!

From: James J. Morrow <>
Date: Fri, 19 Jul 2002 13:23:31 -0800
Message-ID: <>

"Deshpande, Kirti" wrote:
> 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

If it is *that* important to them that they have 9 11i Instances refreshed *that* frequently, they may wish to consider using a three-disk-mirror solution. This would allow you to avoid tape altogether. (Products like EMC's "BCV's" or "Timefinder").

(Sounds like a poorly managed project to me. In all of the projects I've been on I don't think we *ever* refreshed that many databases anywhere near *that* frequently. Normally, I've found that anything beyond 3-4 instances [maybe 5 during an upgrade cycle] is probably unwarranted.)

Personally, I'd seriously question the _real_ business NEED to have *that* many databases and to refresh them quite so frequently.

"The reasonable man adapts himself to the world: the unreasonable man   persists in trying to adapt the world to himself. Therefore all progress    depends on the unreasonable man." -- George Bernard Shaw

Please see the official ORACLE-L FAQ:
Author: James J. Morrow

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: (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).
Received on Fri Jul 19 2002 - 16:23:31 CDT

Original text of this message