RE: Build an exact copy of a database using export / import

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 30 May 2001 11:16:55 -0700
Message-ID: <F001.00313D65.20010530095725@fatcity.com>

We use "Clones" of databases all the time. Its much faster than the Export/import run. We simply take the DB down, copy the data files to a new server in the same file layouts (i.e. ... same directory tree), copy over and change the init file for the new DB name, and bring it up. Then you have to alter the global name. Its a relatively simple process.

If there are tablespaces that were in the original one that you do not want over then, at this point, drop any associated objects and drop the tablespaces.

-----Original Message-----

Sent: Wednesday, May 30, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L

Well, depending on the size of the db and some other network stuff, I do the following. I shut down the real db, copy all of the data files, controlfiles and init file to a machine with Oracle on it. Then you can create the service (NT), alter any of the datafiles if necessary (on different logical drive) then you can just bring that bad boy up. Then I just give it a different alias, works for me.

However, what do you mean it creates new tablespaces, I have never seen
that happen, it just fails miserably for me if the tablespaces don't exist. You could do the full export, create a new user on the new machine and grant "become any user" to the new user. I believe that then the import would work, I've done it before. Sorry I don't have more, brain is still a littel soft from the weekend.
Kev

-----Original Message-----

L.
Sent: Wednesday, May 30, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L

When I build a new test database I create the database and run all the required Oracle scripts. Then I do a full import of a production export. This works pretty well but I miss some of the grants and The full import wants to create tablespaces that I may or may not want created. I get a lot of errors on system objects. Does anyone have the proper steps to create an exact copy of a production database using export / import?

Thanks!
Ron Smith
Database Administration
rlsmith_at_kmg.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Smith, Ron L.
INET: rlsmith_at_kmg.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: Kevin Kostyszyn
INET: kevin_at_dulcian.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

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