RE: Merge datafile to Another DATABASE
- From: <krish.hariharan@xxxxxxxxxxxx>
- To: <enkhbold@xxxxxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 12 Jan 2008 00:05:21 -0700
I will drop another angle that has not been touched in this thread. If this
is a speculative, academic, or an actual situation/question, then the rest
of the threads have addressed that.
However if you are trying to protect the database from such an eventuality
then the correct way to address that is using sound Backup, HA, and DR
policies, that minimize both downtime and data loss. Case in point: I have
administered backups for over 300 dbs ranging from versions 8.0.4 - 10.2.0.3
and every patchset in between, with sizes from a few GB to 30TB over the
last 9 years. In all this time, I have had to only unload one 16K block of
records; about 44 records. The rest of it is handled by Logminer, media
recovery (with outage only to the failed component and its dependents) or by
recovering the databases to alternate hosts and transporting the data.
Regards,
-Krish
Krish Hariharan
President/Executive Architect, Quasar Database Technologies, LLC
<http://www.linkedin.com/in/quasardb> http://www.linkedin.com/in/quasardb
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Enkhbold Dashdondog
Sent: Thursday, January 10, 2008 8: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:
