 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 17 -
Oracle’s Grid Integration Technologies
Convert Files Using RMAN
Use the
Export utility to create the file of metadata information. If you have
not already, move the metadata information file from its location and
the converted datafiles from /tmp/oracle/transport_linux/ to their
respective target directories on the destination host, then plug the
tablespace(s) into the new database with the Import utility.
Example:
Converting Tablespaces on the Target Platform
Suppose you
need to transport tablespaces research (datafiles ‘/oracle/oradata/rec/rec01.dbf'
and ‘/oracle/oradata/rec/rec02.dbf') and pl (datafiles ‘/oracle/oradata/pl/proj01.dbf'
and ‘/oracle/oradata/pl/proj02.dbf') from a source database running on
a Sun Solaris host to a destination database running on an Linux PC
host. You plan to perform conversion on the target host. You will
temporarily store the unconverted datafiles in the directory /tmp/oracle/transport_solaris/
on the target host. When the datafiles are plugged into Oracle, they
will be stored in /oradata/oracle/rec/.
The example
assumes that the following steps have been carried out in preparation
for the tablespace transport:
The source
tablespaces to be transported are set to be read-only, the Export
utility has been used to create the metadata information file (named,
in our example, research.dchmp), the research.dmp and the unconverted
tablespace datafiles to be transported have been gathered and copied
to the destination host, to the '/tmp/oracle/transport_solaris/'
directory.
The
subdirectory structure from the files original location has been
preserved, that is, the datafiles are stored as:
/tmp/oracle/transport_solaris/rec/research01.dbf
/tmp/oracle/transport_solaris/rec/research02.dbf
/tmp/oracle/transport_solaris/pl/proj01.dbf
/tmp/oracle/transport_solarisr/pl/proj02.dbf
For more information,
see the book
Oracle 11g
Grid and Real Application Clusters 30% off if you
buy it directly from Rampant TechPress .
Written by top Oracle
experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
For more
information, please visit
www.praetoriate.com or email
 .
 |
