We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

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.

Clemmie
Clemmie asked
on
Medium Priority
881 Views
Last Modified: 2013-12-18
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.

r,
Clem
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
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.
Sr Software Engineer
CERTIFIED EXPERT
Commented:
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: http://www.experts-exchange.com/simpleSearch.jsp?q=oracle+close+express+database&searchSubmit=1&cid=315&redirectURL=%2F&gSearch=0
 

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Mark GeerlingsDatabase Administrator
CERTIFIED EXPERT
Commented:
"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.
David VanZandtSr Software Engineer
CERTIFIED EXPERT

Commented:
Recommend split
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.