| Reuse Datafile in Other Server [message #433866] |
Fri, 04 December 2009 10:58  |
lr_chandan
Messages: 5
Registered: October 2009
Location: Kolkata
|
Junior Member |
|
|
Hi,
I have 2 Database servers. One is Production another is Test.
Both are having same OS & Oracle Version.
In my Production Server there 2 tablespaces, called ABC which is having 25 dbf files and ABCINDEX is having 25 dbf files.
Both above said table tablespace are available in Test Server with only having 1 DBF file for ABC tablespace and 1 DBF file for ABCINDEX tablespace.
I need to move all the DBF files of ABC & ABCINDEX Tablespace to test server. I am having offline backup of all the DBF files of Production Server.
Please advice me the process to move the files from Production to Test without export/import or expdp/impdp.
Regards,
Chandan.
|
|
|
|
|
|
| Re: Reuse Datafile in Other Server [message #434044 is a reply to message #433866] |
Mon, 07 December 2009 00:19  |
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
|
Junior Member |
|
|
Greetings -
Recommendation 1:
Use the transportable tablespace feature. You'll still have to use exp/imp but not the way you did in Oracle 7 days. Essentially, you'll create a small dump file of the metadata.
You then put those to tablespaces in backup mode, and copy all the datafiles comprising each tablespace to the target server/directory. Then end backup on those two tablespaces.
On the target, you 'import' the transported tablespaces, which means you load the metadata into oracle, and if done correctly, the database will attach correctly to those datafiles.
Recommendation #2:
Use RMAN.
I am not a big fan of RMAN, but depending on the version, it should be possible.
With either, please study the documentation for RMAN and exp/imp (expdp/impdp). RMAN would like be located in the 'BACKUP AND RECOVERY' documentation for your version, while export/import, with or without datapump, will be located in the 'UTILITIES' documentation for your oracle version.
Either, RTFM is often my mantra...
Good luck
Nets Edge
[Updated on: Mon, 07 December 2009 01:36] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: Reuse Datafile in Other Server [message #434109 is a reply to message #434090] |
Mon, 07 December 2009 03:53 |
lr_chandan
Messages: 5
Registered: October 2009
Location: Kolkata
|
Junior Member |
|
|
Alternatively Can I do the following thing ?
Copy all the datafiles in Test Server.
Then "Alter Tablespace add datafiles...Reuse" to add the copied Datafiles in the Tablespace of Test Server.
Will it work ?
|
|
|
|
|
|
| Re: Reuse Datafile in Other Server [message #434120 is a reply to message #434115] |
Mon, 07 December 2009 04:16 |
lr_chandan
Messages: 5
Registered: October 2009
Location: Kolkata
|
Junior Member |
|
|
Hi Michel,
OK...Then can I do the following steps?
Add 24 data fies in ABC Tablespace ( Alter tablespace add datafile....) of Test Server with the same name of data files of Production Server.
Then Shutdown the database and Copy all the data files from Production to in Test Server for ABC Tablespace.
will it work?
Regards,
Chandan
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
