RE: Merge datafile to Another DATABASE
Date: Fri, 11 Jan 2008 12:00:09 -0500
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).
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Enkhbold Dashdondog
Sent: Thursday, January 10, 2008 10:18 PM To: 'oracle-l'
Subject: Merge datafile to Another DATABASE
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?
EnkhboldReceived on Fri Jan 11 2008 - 11:00:09 CST