RE: Merge datafile to Another DATABASE

From: Enkhbold <enkhbold_at_khanbank.com>
Date: Mon, 14 Jan 2008 15:07:08 +0800
Message-ID: <000d01c8567c$1651eb60$42f5c220$@com>

 

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham
Sent: Saturday, January 12, 2008 1:00 AM To: enkhbold_at_khanbank.com; '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_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  

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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 14 2008 - 01:07:08 CST

Original text of this message