Home » RDBMS Server » Backup & Recovery » Reuse Datafile in Other Server (Oracle 10.2.0.4 , HP-UX 11.31)
Reuse Datafile in Other Server [message #433866] Fri, 04 December 2009 10:58 Go to next message
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 #433868 is a reply to message #433866] Fri, 04 December 2009 11:05 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>Please advice me the process to move the files from Production to Test without export/import or expdp/impdp.
1) on Production SHUTDOWN IMMEDIATE
2) on Test SHUTDOWN IMMEDIATE
3) copy all files from Production to TEST
4) on Production STARTUP
5) on Test STARTUP
Re: Reuse Datafile in Other Server [message #434044 is a reply to message #433866] Mon, 07 December 2009 00:19 Go to previous messageGo to next message
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 #434069 is a reply to message #433868] Mon, 07 December 2009 02:02 Go to previous messageGo to next message
lr_chandan
Messages: 5
Registered: October 2009
Location: Kolkata
Junior Member
Hi BlackSwan,

I think you solution will not work as No. of Datafiles are not same in Production and Test.
Regards,
Chandan.
Re: Reuse Datafile in Other Server [message #434072 is a reply to message #433866] Mon, 07 December 2009 02:06 Go to previous messageGo to next message
lr_chandan
Messages: 5
Registered: October 2009
Location: Kolkata
Junior Member
Actually I want to clone the Tablespace. Can anyone help me?
Re: Reuse Datafile in Other Server [message #434077 is a reply to message #434072] Mon, 07 December 2009 02:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at "transportable tablespace".

Regards
Michel

[Updated on: Mon, 07 December 2009 02:25]

Report message to a moderator

Re: Reuse Datafile in Other Server [message #434090 is a reply to message #434069] Mon, 07 December 2009 02:56 Go to previous messageGo to next message
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
Junior Member
Drop the tablespaces in test 'including contents and datafiles' before proceeding.

Do read up before attempting.

NEts Edge
Re: Reuse Datafile in Other Server [message #434109 is a reply to message #434090] Mon, 07 December 2009 03:53 Go to previous messageGo to next message
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 #434115 is a reply to message #434109] Mon, 07 December 2009 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it will not work unless you copy the whole database as BlackSwan said in the first answer.

Regards
Michel
Re: Reuse Datafile in Other Server [message #434120 is a reply to message #434115] Mon, 07 December 2009 04:16 Go to previous messageGo to next message
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
Re: Reuse Datafile in Other Server [message #434122 is a reply to message #434120] Mon, 07 December 2009 04:34 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Click on the link I provided.

Regards
Michel
Previous Topic: backup portal only
Next Topic: BACKUP problam???
Goto Forum:
  


Current Time: Wed Dec 07 06:56:59 CST 2016

Total time taken to generate the page: 0.19135 seconds