• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

transport database in oracle

Could you please let me know how to transport database in oracle..
0
nobleit
Asked:
nobleit
1 Solution
 
Swadhin RaySenior Technical Engineer Commented:
Find the control files location .
rename the control_files instance parameter..
SHUTDOWN IMMEDIATE the database
Rename the physical file on the OS
restart the database.


For more detail information you can go to :
http://www.oracle-base.com/articles/misc/RenamingOrMovingOracleFiles.php


0
 
slightwv (䄆 Netminder) Commented:
Please explain what you mean by 'transport database'.

Do you mean transportable tablespaces?  
Moving the database to a different machine?  
Creating a 'copy' of a database on a different machine?

What database version? Techniques can change across versions.

For the first one, check the online docs:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm

If the last two, please check out RMAN cloning. Again, the docs:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc2.htm#i1006532
0
 
mrjoltcolaCommented:
@slobaray: Your directions tell the OP how to rename a control file. How is that related to the question?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
nobleitAuthor Commented:
copy the database in differenct machine.
0
 
slightwv (䄆 Netminder) Commented:
Ok, did you check the link I posted about rman clone/duplicate?
0
 
Swadhin RaySenior Technical Engineer Commented:
@nobleit  can't you go with export and import , and also what slightwv: has suggested with RMAN will slove your problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now