oracle数据集库管理-12C新特性TTS

1 相同字符序
[oracle@vm01 Desktop]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Tue Dec 17 13:25:09 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PRODPRI (DBID=2060108401)

RMAN> alter tablespace users read only;

using target database control file instead of recovery catalog
Statement processed

RMAN> backup for transport
2> format '/home/oracle/123.dbf'
3> tablespace users
4> datapump format '/home/oracle/123.dmp';

Starting backup at 17-DEC-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=51 device type=DISK
Running TRANSPORT_SET_CHECK on specified tablespaces
TRANSPORT_SET_CHECK completed successfully

Performing export of metadata for specified tablespaces...
   EXPDP> Starting "SYS"."TRANSPORT_EXP_PRODPRI_tFvs":  
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
   EXPDP> Master table "SYS"."TRANSPORT_EXP_PRODPRI_tFvs" successfully loaded/unloaded
   EXPDP> ******************************************************************************
   EXPDP> Dump file set for SYS.TRANSPORT_EXP_PRODPRI_tFvs is:
   EXPDP>   /u01/app/oracle/product/12.2/db_1/dbs/backup_tts_PRODPRI_66624.dmp
   EXPDP> ******************************************************************************
   EXPDP> Datafiles required for transportable tablespace USERS:
   EXPDP>   /u01/oradata/prodpri/users01.dbf
   EXPDP> Job "SYS"."TRANSPORT_EXP_PRODPRI_tFvs" successfully completed at Tue Dec 17 13:26:56 2019 elapsed 0 00:00:35
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=00007 name=/u01/oradata/prodpri/users01.dbf
channel ORA_DISK_1: starting piece 1 at 17-DEC-19
channel ORA_DISK_1: finished piece 1 at 17-DEC-19
piece handle=/home/oracle/123.dbf tag=TAG20191217T132607 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
input Data Pump dump file=/u01/app/oracle/product/12.2/db_1/dbs/backup_tts_PRODPRI_66624.dmp
channel ORA_DISK_1: starting piece 1 at 17-DEC-19
channel ORA_DISK_1: finished piece 1 at 17-DEC-19
piece handle=/home/oracle/123.dmp tag=TAG20191217T132607 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-DEC-19

RMAN> 

Solaris[tm] OE (64-bit)

2 不同字符序

backup to platform 'Solaris[tm] OE (64-bit)'
format '/home/oracle/123_%u.dbf'
tablespace users,users01
datapump format '/home/oracle/two.dmp';

RMAN> backup to platform 'Solaris[tm] OE (64-bit)'
format '/home/oracle/123_%u.dbf'
tablespace users,users01
datapump format '/home/oracle/two.dmp';

Starting backup at 17-DEC-19
using channel ORA_DISK_1
Running TRANSPORT_SET_CHECK on specified tablespaces
TRANSPORT_SET_CHECK completed successfully

Performing export of metadata for specified tablespaces...
   EXPDP> Starting "SYS"."TRANSPORT_EXP_PRODPRI_xFrk":  
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
   EXPDP> Processing object type TRANSPORTABLE_EXPORT/TABLE
   EXPDP> Master table "SYS"."TRANSPORT_EXP_PRODPRI_xFrk" successfully loaded/unloaded
   EXPDP> ******************************************************************************
   EXPDP> Dump file set for SYS.TRANSPORT_EXP_PRODPRI_xFrk is:
   EXPDP>   /u01/app/oracle/product/12.2/db_1/dbs/backup_tts_PRODPRI_35757.dmp
   EXPDP> ******************************************************************************
   EXPDP> Datafiles required for transportable tablespace USERS:
   EXPDP>   /u01/oradata/prodpri/users01.dbf
   EXPDP> Datafiles required for transportable tablespace USERS01:
   EXPDP>   /home/oracle/users0001.dbf
   EXPDP> Job "SYS"."TRANSPORT_EXP_PRODPRI_xFrk" successfully completed at Tue Dec 17 13:35:40 2019 elapsed 0 00:00:28
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=00007 name=/u01/oradata/prodpri/users01.dbf
input datafile file number=00002 name=/home/oracle/users0001.dbf
channel ORA_DISK_1: starting piece 1 at 17-DEC-19
channel ORA_DISK_1: finished piece 1 at 17-DEC-19
piece handle=/home/oracle/123_09ujle5d.dbf tag=TAG20191217T133502 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
input Data Pump dump file=/u01/app/oracle/product/12.2/db_1/dbs/backup_tts_PRODPRI_35757.dmp
channel ORA_DISK_1: starting piece 1 at 17-DEC-19
channel ORA_DISK_1: finished piece 1 at 17-DEC-19
piece handle=/home/oracle/two.dmp tag=TAG20191217T133502 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 17-DEC-19

RMAN> exit