Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

RE: DB copying : Attack of the Clones!

From: Gesler, Rich <RGesler_at_lexington.com>
Date: Fri, 19 Jul 2002 08:08:26 -0800
Message-ID: <F001.0049CAA8.20020719080826@fatcity.com>


Kirti,

I'm reading between the lines here but I get the feeling that you believe you can only clone from a cold backup? A less disruptive means would be to clone from a hot backup.

My current backup setup is a central server with a disk farm. These file systems are NFS mounted to the various database servers via an out-of-band network. That way I can push or pull data without killing the production network. My hot backup uses remote copy (rcp) so the backup server does the bulk of the work. After the backup is made to disk then we go to tape.

The biggest pain in all of this is keeping up with a file system mapping for the test system. Generally test servers do not have the luxury of production's spindle spread. You can keep some sort of a table to map out the production to test layout. From this table you can generate the appropriate script to copy from your backup area to the test server.

I would love to have EMC / Timefinder to do the mirror splitting but no $$$$$ here!

Hope this helps,
Rich Gesler

-----Original Message-----
Sent: Thursday, July 18, 2002 10:08 PM
To: Multiple recipients of list ORACLE-L

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.

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: Gesler, Rich
  INET: RGesler_at_lexington.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). Received on Fri Jul 19 2002 - 11:08:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US