Hello,I have an Oracle 10g Express Edition Database that I need to clone from one machine to another. How can I do this without having to use the export/import utilities? Thank you in advance.

Posted on 2009-02-09
Last Modified: 2013-12-18

I have an Oracle 10g Express Edition Database that I need to clone from one machine to another. How can I do this without having to use the export/import utilities?

Thank you in advance.

Question by:Clemmie
    LVL 47

    Expert Comment

    You can give a try to use DBCA utility and create a template file.
    After that move this file(s) to the Template directory of the other instance.
    Create a new DB using DBCA and choose that template file.

    The most common way is to do a cold backup and after that to restore the DB
    on the new place. I have posted so much time the instruction that I am sure a search here will reveal you detailed instructions.
    LVL 23

    Accepted Solution

    The hard way.  Shut down the instance, copy all relevant disk files to the new host, and restart the database.  Assuming, of course, that you have remembered things like your oratab, TNS_ADMIN and other environment variables, firewall and router ports, and client-based tnsnames.ora files.  I suspect if you searched EE (textbox, top right of your window) for "Oracle express database clone" that you would find many related hits on the exact procedure.  Here's my shortcut to the result set:
    LVL 34

    Assisted Solution

    "The hard way" isn't really so hard.  You first need to have the Oracle XE software installed on the second machine, and you need to create a starter database there with the same SID as the one you want to clone.  (I think if you used the default values when you created the original database and the new one, they should have the same SID name.)

    Now, you need to find all of the:
    1. data files (tablespaces)
    2. on-line redo log files
    3. control files

    These three queries can do that for you.  You need to run them in the database that you want to clone
    (log in as SYS or SYSTEM to run these):

    select name from v$datafile
    union all
    select name from v$tempfile;

    select member from v$logfile;

    select name from v$controlfile;

    Those queries will give you the file names and the full path to each file.  Shut down the database you want to clone, and shutdown the "starter" database on the new machine, then copy all of these files to the same locations on the new machine.  Now you can re-start the original database,  and you should be able to start the cloned database on the new machine as well.
    LVL 23

    Expert Comment

    Recommend split

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    substr - oracle 5 49
    Oracle SQL Update Statement Query Syntax 3 46
    Stay Alert! 13 47
    Adding a blank row when using union all 4 37
    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now