Databases Reference
In-Depth Information
Performing export of metadata for specified tablespaces...
EXPDP> Starting "SYSBACKUP"."TRANSPORT_EXP_ORCL_omwi":
EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
EXPDP> Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
EXPDP> Master table "SYSBACKUP"."TRANSPORT_EXP_ORCL_omwi" successfully loaded/unloaded
EXPDP> ******************************************************************************
EXPDP> Dump file set for SYSBACKUP.TRANSPORT_EXP_ORCL_omwi is:
EXPDP> /u01/app/oracle/product/12.1.0/db_1/dbs/backup_tts_ORCL_87665.dmp
EXPDP> ******************************************************************************
EXPDP> Datafiles required for transportable tablespace DEMO:
EXPDP> /u01/app/oracle/oradata/orcl/demo01.dbf
EXPDP> Job "SYSBACKUP"."TRANSPORT_EXP_ORCL_omwi" successfully completed at Sat Nov 27
17:29:48 2012 elapsed 0 00:01:34
Export completed
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/orcl/demo01.dbf
channel ORA_DISK_1: starting piece 1 at 27-NOV-12
channel ORA_DISK_1: finished piece 1 at 27-NOV-12
piece handle=/u02/app/oracle/oradata/transport_aknoqnt8 tag=TAG20121027T172711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
input Data Pump dump file=/u01/app/oracle/product/12.1.0/db_1/dbs/backup_tts_ORCL_87665.dmp
channel ORA_DISK_1: starting piece 1 at 27-NOV-12
channel ORA_DISK_1: finished piece 1 at 27-NOV-12
piece handle=/u02/app/oracle/oradata/export/trans_ts_alnoqntd_1_1 tag=TAG20121027T172711
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-NOV-12
RMAN>
In this example, we chose to use the
to platform
clause, so any necessary conversion of the endian format of
the destination database data files is performed on the source database. If you want the conversion of the endian
formats to take place on the destination server, you must specify the
for transport
clause instead with your
backup
command (
backup for transport
...
) . Note that the
format
clause specifies the format of the backup piece.
The
backup to platform
command produces both a Data Pump dump file set with the metadata for the
tablespace
demo
, as well as an RMAN backup set that contains the backup of the tablespace
demo
, which we want to
export to the destination database.
7.
Use OS utilities to move the backup sets you've made in the previous step to the
destination database host.
8.
Connect to RMAN with the destination database as the target.
$ RMAN
$ connect target sysbackup@orcl1 as sysbackup;
9.
Finally, restore the backup sets that you transported from the source database (orcl) into
the destination database (orcl1).
