RE: Merge datafile to Another DATABASE

  • From: "Enkhbold" <enkhbold@xxxxxxxxxxxx>
  • To: <mwf@xxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Jan 2008 15:07:08 +0800

 

Thanks for reply to me. 

The store is Database is damaged /system tablespace and datafile is broken/,
user tablespace and datafiles are fine. 

Also no backup was there. 

So only solution that if it works, is to build new database in another
server and merge User Datafile into the New Database. 

 

 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mark W. Farnham
Sent: Saturday, January 12, 2008 1:00 AM
To: enkhbold@xxxxxxxxxxxx; 'oracle-l'
Subject: RE: Merge datafile to Another DATABASE

 

Someone already mentioned using transportable tablespaces, if that fits for
you.

 

I want to back up to suppress an apparent misconception.

 

If you've got two separate servers, you might have two instances of the same
database (through RAC or the venerable OPS), or you might have two different
databases that look very similar to each other, or you might have a standby
of one database on another server.

 

In the first case, the files are shared and therefore there would be no
point to your question, and in the last case you probably would have
mentioned either dataguard or homegrown standby software, so I think you
have two different databases. Raising this point might seem pedantic, but
with the increasing use of RAC, standbys and "grids" it is very important to
keep the terminology clear.

 

Now if transportable tablespaces won't work for you, there are a couple of
companies out there that have utilities designed to scan datafiles to
produce files useful for loading your data from a damaged database that
cannot be started from the datafiles of tablespaces that remain viable.
You'll need to be specific with them about what release, and I do not think
any of them operate as a free service (nor am I suggesting they should).

 

Regards,

 

mwf

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Enkhbold Dashdondog
Sent: Thursday, January 10, 2008 10:18 PM
To: 'oracle-l'
Subject: Merge datafile to Another DATABASE

 

Hi 

 

I have two different Database server (A, B) with same Database. 

If A server database is damaged, but A_USER_ Datafile is fine. 

In A Server, export and expdp are not working. 

 

Is possible get A_USER_Datafile and merge to B database? 

 

Enkhbold 

Other related posts: