Re: DB copying : Attack of the Clones!

"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.

• James

  ---

  James J. Morrow E-Mail: jmorrow_at_warthog.com Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA

"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: http://www.orafaq.com
-- 
Author: James J. Morrow
  INET: jmorrow_at_warthog.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).