OraFAQ Forum: Server Utilities » How to choose between exp/imp or clone by copying data files ?

Home » RDBMS Server » Server Utilities » How to choose between exp/imp or clone by copying data files ? (Oracle 9i, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to choose between exp/imp or clone by copying data files ? [message #423265]

Wed, 23 September 2009 03:17

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.

Report message to a moderator

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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.)

Report message to a moderator

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Flashback queries.
Next Topic:	Unescaped quotes & External Tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 01:34:04 CST 2024