TTS备份实验
-
查看系统版本支持的系统
1 SQL> select * from v$TRANSPORTABLE_PLATFORM ORDER BY PLATFORM_NAME; 2 3 PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT 4 ----------- ------------------------------------ -------------- 5 6 AIX-Based Systems (64-bit) Big 6 16 Apple Mac OS Big 7 21 Apple Mac OS (x86-64) Little 8 19 HP IA Open VMS Little 9 15 HP Open VMS Little 10 5 HP Tru64 UNIX Little 11 3 HP-UX (64-bit) Big 12 4 HP-UX IA (64-bit) Big 13 18 IBM Power Based Linux Big 14 9 IBM zSeries Based Linux Big 15 10 Linux IA (32-bit) Little 16 17 PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT 18 ----------- ------------------------------------ -------------- 19 11 Linux IA (64-bit) Little 20 13 Linux x86 64-bit Little 21 7 Microsoft Windows IA (32-bit) Little 22 8 Microsoft Windows IA (64-bit) Little 23 12 Microsoft Windows x86 64-bit Little 24 17 Solaris Operating System (x86) Little 25 20 Solaris Operating System (x86-64) Little 26 1 Solaris[tm] OE (32-bit) Big 27 2 Solaris[tm] OE (64-bit) Big 28 29 20 rows selected.
我源的机器是 Linux x86 64-bit ，参考官方文档，如果两个平台不同，则表空间需要转化。我这边是从 linux 到windows
特别需要注意一些限制，系统表空间，SYS用户对象等。
2. 查询表空间是否为自包含
SQL> EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('TTS_TPS', TRUE); PL/SQL procedure successfully completed.
查询视图
SQL> select * from TRANSPORT_SET_VIOLATIONS; no rows selected
没有记录就是符合条件，没有字包含。
3.Generate a Transportable Tablespace Set 修改表空间为只读
SQL> alter tablespace tts_tps read only; Tablespace altered.
4. 创建目录
SQL> create directory dir_cyf as '/tmp/dir_cyf'; Directory created. SQL> grant read,write on directory dir_cyf to public; Grant succeeded.
5.数据导出
[oracle@evancao dir_cyf]$ expdp system/a123456 dumpfile=aaaa.dmp directory=dir_cyf transport_tablespaces=TTS_TPS logfile=exp_cyf.log Export: Release 11.2.0.3.0 - Production on Thu Dec 25 00:51:35 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** dumpfile=aaaa.dmp directory=dir_cyf Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 320 KB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/PRE_TABLE_ACTION Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/VIEW/COMMENT Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA . . exported "SYSTEM"."REPCAT$_AUDIT_ATTRIBUTE" 6.328 KB 2 rows . . exported "SYSTEM"."REPCAT$_OBJECT_TYPES" 6.882 KB 28 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION_METHOD" 5.835 KB 19 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_STATUS" 5.484 KB 3 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_TYPES" 6.289 KB 2 rows . . exported "SYSTEM"."DEF$_AQCALL" 0 KB 0 rows . . exported "SYSTEM"."DEF$_AQERROR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_CALLDEST" 0 KB 0 rows . . exported "SYSTEM"."DEF$_DEFAULTDEST" 0 KB 0 rows . . exported "SYSTEM"."DEF$_DESTINATION" 0 KB 0 rows . . exported "SYSTEM"."DEF$_ERROR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_LOB" 0 KB 0 rows . . exported "SYSTEM"."DEF$_ORIGIN" 0 KB 0 rows . . exported "SYSTEM"."DEF$_PROPAGATOR" 0 KB 0 rows . . exported "SYSTEM"."DEF$_PUSHED_TRANSACTIONS" 0 KB 0 rows . . exported "SYSTEM"."MVIEW$_ADV_INDEX" 0 KB 0 rows . . exported "SYSTEM"."MVIEW$_ADV_PARTITION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_AUDIT_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_COLUMN_GROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_CONFLICT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_DDL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_EXCEPTIONS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_EXTENSION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_FLAVORS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_GENERATED" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_GROUPED_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_INSTANTIATION_DDL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_KEY_COLUMNS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_OBJECT_PARMS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PARAMETER_COLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PRIORITY" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_PRIORITY_GROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REFRESH_TEMPLATES" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCAT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCATLOG" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPCOLUMN" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPGROUP_PRIVS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPOBJECT" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPPROP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_REPSCHEMA" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOLUTION_STATISTICS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RESOL_STATS_CONTROL" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_RUNTIME_PARMS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SITES_NEW" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SITE_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_SNAPGROUP" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_PARMS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_REFGROUPS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_SITES" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_TEMPLATE_TARGETS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB 0 rows . . exported "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB 0 rows . . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB 0 rows Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /tmp/dir_cyf/aaaa.dmp Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 00:52:42
6.rman导出数据：
RMAN TARGET / RMAN> CONVERT TABLESPACE tts_tps 2> TO PLATFORM 'Microsoft Windows x86 64-bit' 3> FORMAT '/tmp/dir_cyf/aaaa01.dbf'; Starting conversion at source at 25-DEC-14 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile conversion input datafile file number=00009 name=/app/oracle/oradata/orcl/tts01.dbf converted datafile=/tmp/dir_cyf/aaaa01.dbf channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:16 Finished conversion at source at 25-DEC-14
7.拷贝dmp 数据定义文件和dbf 数据文件到目标库服务器
8.在目标库中，执行转换
CONVERT DATAFILE 'D:\tts01.dbf' TO PLATFORM="Microsoft Windows x86 64-bit" FROM PLATFORM="Linux x86 64-bit" format 'D:\tts02.dbf';
9.执行导
impdp tts/tts dumpfile=aaaa01.dmp directory=c_dir transport_datafiles= d:\TTS02.DBF logfile=tts_import.log
