Re: Database cloning

Greetings.
If you would like to be able to clone Oracle databases without having to write all your owmn scripts and SQL to do it, then a product from Princeton Softech, called 'Move for Servers' could well be your answer.

This is a relational data extraction and insertion tool that allows the user to extract either all or a relationally intact sub-set of data from a series of tables. It also allows the extraction of the defining DDL from the source tables (indexes tables etc). This extract can then be used to clone the source database at the target database. However, the user can also tailor both the object definitions, and the inserted data at insertion, to satisfy particular project requirements. For example date aging (either linear or semantic). If you would like any more information, please contact me at the below address, phone, or e-mail me.

Thanks.
In article <35de15c8.356936617_at_news.cyberus.ca>, RP DATA SOLUTIONS <rpdata_at_cyberus.ca> writes
>lofftjm_at_itec.suny.edu wrote:
>
>>Can anyone supply me with, or point me to a location that has information
>>about cloning Oracle databases? The Oracle manuals do not have it listed
>>as a topic in the index and I was only able to come up with limited
>>information from Oracle's Metalink.
>>
>>Any help would be greatly appreciated.
>>
>>Joseph Lofft
>>lofftjm_at_itec.suny.edu
>>
>>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>Here's is one method I use to clone databases... you could also
>create a database from scratch and do an import of the full database
>export from the existing DB..
>
>Here it is..
>1.) From your source database issue the command 'alter database backup
>controlfile to trace' , this will create a .trc file which you will
>modify and rename to a .sql file. You will use this file for two
>things: first, to create a copy script to copy all the files listed in
>it to a new location where you would like them to be for your second
>instance. Secondly, you will then use it to create your control file
>for your second instance.. remove any comments, modify the locations
>of all the files and change the following
><create control file reuse database "dbname" noresetlogs> to
><create control file set database "newdbname" resetlogs>.
>and make sure the last line reads alter database open resetlogs
>
>3.) shutdown the source database
>
>2.) set ORACLE_SID to the new value for your second instance.
>
>3.) create new initsid.ora and configsid.ora files for your second
>instance(I copy them from the other instance), modify them to reflect
>the new sid and file locations of the second instance.
>
>4.) run the script that will copy all your data files
>
>5.) svrmgrl
>
>6.) run your create control file .sql file and BE SURE all references
>to files are actually pointing the NEW locations and not those
>belonging to the other instance.
>
>Don't forget to have complete backups before doing all this and
>you will have to add this instance to any sqlnet related .ora
>files,oratab etc.......
>
>Good Luck
>
>Robert Prendin
>Email if you have any questions....
>YATFG
>#****************************************************
># RP Data Solutions Inc.
># Specializing in ORACLE DBA Support Services
># We offer 24HR remote DBA support!!!
>#****************************************************
>
>

Best regards
--
  Alan Johns
  Tarragon Software Ltd - UK & Ireland Distributor for

        Princeton Softech's -   Upgrade 2000
                                Ager 2000
                                Relational Tools for DB2
                                Move for Servers - Oracle
                                Version Merger
        
        ELISE - the MatchMaker. Software for recruitment, estate agencies,      
                                dating agencies, etc from WCC

Phone: 44(0)1480 414141
  Fax: 44(0)1480 436869 Received on Mon Aug 24 1998 - 09:16:26 CDT