Home » RDBMS Server » Server Utilities » How to choose between exp/imp or clone by copying data files ? (Oracle 9i, AIX)
How to choose between exp/imp or clone by copying data files ? [message #423265] Wed, 23 September 2009 03:17 Go to next message
psoftneto
Messages: 44
Registered: July 2008
Member
Hi all,

I would like to know what should be taken into account when we want to clone one database to another already existing database.

1. When to choose exp/imp
2. When to copy data files and recreate control file

Thanks for your help.
Re: How to choose between exp/imp or clone by copying data files ? [message #423272 is a reply to message #423265] Wed, 23 September 2009 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I would like to know what should be taken into account when we want to clone one database to another already existing database.

In this case it is not cloning, it is importing/embedding.
You then have 3 choices:
1/ standard export/import (or datapump)
2/ transportable tablespaces

Regards
Michel
Re: How to choose between exp/imp or clone by copying data files ? [message #433721 is a reply to message #423272] Thu, 03 December 2009 16:18 Go to previous messageGo to next message
psoftneto
Messages: 44
Registered: July 2008
Member
Hi,

To have a good performance, instead of doing export from database A and import on database B.

Will you recommend using a materialized view on database B and a materialized view log on database A.

I would to store only new lines on the materialized view log on database A and refresh materialized view on database B using dblink.

Thanks.
Re: How to choose between exp/imp or clone by copying data files ? [message #433753 is a reply to message #433721] Fri, 04 December 2009 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your need and environment.
Real time or deferred copy? What is the allowed gap? Can you stop activity on source table or not? What is the size of the table? What is the activity on it? What is the speed of your network? Is there any network between the 2?...

Regards
Michel

[Updated on: Fri, 04 December 2009 00:57]

Report message to a moderator

Re: How to choose between exp/imp or clone by copying data files ? [message #433763 is a reply to message #433753] Fri, 04 December 2009 02:23 Go to previous messageGo to next message
psoftneto
Messages: 44
Registered: July 2008
Member
Hi Michel,

The table has more than 20G. Since we will refresh only new lines one time/day (not real time). It will surely be faster than exporting and importing the all table.

We have additional 4Go/year.

Thanks.
Re: How to choose between exp/imp or clone by copying data files ? [message #433767 is a reply to message #433763] Fri, 04 December 2009 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
4G/year means ~10M each day, if the network is not bad then mview seems to be the best choice maybe with a refresh each hour or half hour to spread the io and network traffic all over the day.

Regards
Michel
Re: How to choose between exp/imp or clone by copying data files ? [message #434045 is a reply to message #423265] Mon, 07 December 2009 00:37 Go to previous messageGo to next message
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
Junior Member
Again, an arbitrary post with too little information.

Database Version? Standard or Enterprise ?

For 10g(or higher) Enterprise, I would recommend streams. Pretty straight forward for a single table, or even a singly schema.

Of course, there are plenty of different options....

Peace

The Nets Edge

(sadly I was informed Oracle will be ending all R & D efforts as it relates to Streams, as they are completing their acquisition of GoldenGate.)
Re: How to choose between exp/imp or clone by copying data files ? [message #434056 is a reply to message #434045] Mon, 07 December 2009 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Database Version?

9i. It is in the title.
This is why I didn't mention Streams.

Regards
Michel

[Updated on: Mon, 07 December 2009 01:27]

Report message to a moderator

Re: How to choose between exp/imp or clone by copying data files ? [message #434059 is a reply to message #423265] Mon, 07 December 2009 01:33 Go to previous messageGo to next message
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
Junior Member
Sorry - bad habbit of reading the subject without the title.


But how sad is it, Oracle 9i ?

Isn't that unsupported now? I know, I know. Even in my diamond mine, we have unsupported databases. Couple 7.3's, a few 8.0's, about a dozen 8i's...

It's so so sad. Will be deploying 11gR2's this month and next. 6 versions of Oracle, on over a dozen platforms, throw in a few RAC Clusters with a bit of streams.

You'd think management does this cr*p just to kill the DBA's. (Only 4 of us for 130+ db's, and tools...well there's putty....)

They hate us


Nets Edge
Re: How to choose between exp/imp or clone by copying data files ? [message #434075 is a reply to message #434059] Mon, 07 December 2009 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How lucky you are! We have (at this very moment but this will change along the day) 1575 Oracle databases from 7.1 (on VMS) to 11.2.

Regards
Michel
Re: How to choose between exp/imp or clone by copying data files ? [message #434094 is a reply to message #434075] Mon, 07 December 2009 02:59 Go to previous message
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
Junior Member
VMS was the very best platform to run Oracle on.

GS1280's ROCK !!!

My current environment, we have 7.1's, 7.3's and 8i's on vms. No 1280s though.

Did several years as a VMS SysAdmin too. The most stable hardware I have ever been near. Too bad they killed it.

Nets Edge
Previous Topic: Flashback queries.
Next Topic: Unescaped quotes & External Tables
Goto Forum:
  


Current Time: Thu Mar 28 11:07:40 CDT 2024