Re: DB copying : Attack of the Clones!

I have clones of my production databases on another node running the same OS version. The clone's OS and env should be the same and the filesysems should be the same to avoid have to rename datafiles into another place. This is a real pain, but not impossible. You have to do a level 0 rman backup and then restore it to the clone.

Let me know off-list if you need any more info about this.

Regards,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, July 19, 2002 2:28 PM

> I have not looked into RMAN 'duplicate' method, as RMAN is still not
> practiced at my work place.
> But may be this is the time to consider it. I will do the required reading
> of manuals etc, but can it move files to other servers as cloned databases
> will be on different servers (same platform, though)?
>
> Thanks.
>
> - Kirti
>
> > -----Original Message-----
> > From: Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
> > Sent: Friday, July 19, 2002 9:33 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: DB copying : Attack of the Clones!
> >
> > Kirti,
> > How about the 'duplicate' command in rman (8i or>)? I do hand clones
> > using
> > rman. It is not that hard, but the duplicate command is easier.
> >
> > Regrads,
> > Ruth
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, July 18, 2002 10:08 PM
> >
> >
> > > Listers,
> > > I was 'volunteered' to participate in a task force charged with
finding
> > > quick solutions (in less than 2 weeks) to support following Dgmt
> > decision:
> > > Clone 14 production databases in their entirety for ongoing code
> > testing,
> > > recreating production problems etc.
> > >
> > > The cloned databases will have to be renamed, the db links
> > re-established,
> > > the access privileges for a dozen or so accounts relaxed (password
> > changed,
> > > access to stored procedures etc). The clones will be tampered with but
> > will
> > > need to be kept in sync with production database on a weekly or
> > bi-weekly
> > > basis. The size of databases ranges from 50GB to over 150GB (and
> > growing,
> > of
> > > course).
> > > Are there any 'silver bullet' tools anyone heard of that can do this
in
> > a
> > > flash? Current method of cold backup is too time consuming and
> > disruptive.
> > >
> > > All these databases are on HDS disk arrays. I have been playing with
> > HDS'
> > > ShadowImage product for some other project. I have suggested using
this
> > > product for solving this problem. But, I am not an authority on this
> > > product. My idea being, the 'split' disks (from sort-of 3rd mirror)
will
> > > become the clones. When the clones need refreshing, those disks will
be
> > > 're-silvered' and 'split' again. Other thing I may consider is the hot
> > > backup. But, I am sure it will be shot down as being too time
consuming.
> > >
> > > Is anyone currently doing anything like this? What tools are you
using?
> > >
> > > BTW, if we decided on any 3rd party tools, then Dgmt wants it
installed
> > > within the next 4-5 weeks. Any Vendor types lurking on the list? This
is
> > > your chance :)
> > >
> > > 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).
> --
> 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).