\u4e00\u3001\u4f20\u8f93\u8868\u7a7a\u95f4\u6982\u8ff0<\/p>\n\n\n\n
\u5728Oracle\u73af\u5883\u4e2d\uff0c\u6709\u5f88\u591a\u65b9\u6cd5\u53ef\u4ee5\u5bf9\u6570\u636e\u8fdb\u884c\u5907\u4efd\u548c\u4f20\u8f93\uff0c\u50cf\u662fexp\/imp\u3001expdp\/impdp\u548crman\u7b49\u3002\u800c\u53ef\u4f20\u8f93\u8868\u7a7a\u95f4\uff08Transportable Tablespace\uff09\u4e5f\u662f\u65b9\u6cd5\u4e4b\u4e00\u3002\n\u4f20\u8f93\u8868\u7a7a\u95f4\u6280\u672f\u5728oracle9i\u5f00\u59cb\u51fa\u73b0\uff0c \u7531\u4e8e\u4f20\u8f93\u8868\u7a7a\u95f4\u53ea\u662f\u590d\u5236\u5305\u542b\u5b9e\u9645\u6570\u636e\u7684\u6570\u636e\u6587\u4ef6\u5230\u76ee\u6807\u6570\u636e\u5e93\u7684\u6307\u5b9a\u4f4d\u7f6e\uff0c\u800c\u4f7f\u7528\u6570\u636e\u6cf5\u5219\u662f\u4f20\u8f93\u8868\u7a7a\u95f4\u5bf9\u8c61\u7684\u5143\u6570\u636e\u5230\u76ee\u6807\u6570\u636e\u5e93\u3002\u6240\u4ee5\u4f20\u8f93\u8868\u7a7a\u95f4\u7684\u901f\u5ea6\u4e00\u822c\u8f83\u5feb\u3002<\/p>\n\n\n\n
\u4e8c\u3001\u4f20\u8f93\u8868\u7a7a\u95f4\u5b9e\u9a8c<\/p>\n\n\n\n
1.\u4f20\u8f93\u524d\u7684\u68c0\u67e5<\/p>\n\n\n\n
\u68c0\u67e5\u5e73\u53f0<\/p>\n\n\n\n
\u82e5\u662f\u5e73\u53f0\u4e0d\u540c\uff0c\u9700\u8981\u5bf9\u5bfc\u51fa\u7684\u6587\u4ef6\u8fdb\u884c\u8f6c\u6362\u518d\u5bfc\u5165\u3002\u8fd9\u91cc\u7684\u4e24\u4e2a\u5e73\u53f0\u90fd\u662fLinux IA (32-bit) \u3002<\/p>\n\n\n\n
SQL> select d.platform_name,\ntp.endian_format<\/p>\n\n\n\n
from v$transportable_platform tp,\nv$database d<\/p>\n\n\n\n
where tp.platform_name =\nd.platform_name; 2 3 <\/p>\n\n\n\n
PLATFORM_NAME ENDIAN_FORMAT<\/p>\n\n\n\n
————————————————–\n————–<\/p>\n\n\n\n
Linux IA (32-bit) Little<\/p>\n\n\n\n
\u53ef\u4ee5\u901a\u8fc7\u4e0b\u9762\u8bed\u53e5\u67e5\u770boracle\u652f\u6301\u90a3\u4e9b\u5e73\u53f0\u7684\u4f20\u8f93\u8868\u7a7a\u95f4\uff08\u53ef\u4ee5\u4e0d\u540c\u5e73\u53f0\u4e4b\u95f4\u8fdb\u884c\u4f20\u8f93\uff09<\/p>\n\n\n\n
SQL> col PLATFORM_NAME format a30<\/p>\n\n\n\n
SQL> select * from\nv$transportable_platform order by platform_name;<\/p>\n\n\n\n
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT<\/p>\n\n\n\n
———– ——————————\n————–<\/p>\n\n\n\n
\n6 AIX-Based Systems (64-bit) \nBig<\/p>\n\n\n\n
\n16 Apple Mac OS \nBig<\/p>\n\n\n\n
\n21 Apple Mac OS (x86-64) \nLittle<\/p>\n\n\n\n
\n19 HP IA Open VMS \nLittle<\/p>\n\n\n\n
\n15 HP Open VMS \nLittle<\/p>\n\n\n\n
\n5 HP Tru64 UNIX \nLittle<\/p>\n\n\n\n
\n3 HP-UX (64-bit) \nBig<\/p>\n\n\n\n
\n4 HP-UX IA (64-bit) Big<\/p>\n\n\n\n
\n18 IBM Power Based Linux \nBig<\/p>\n\n\n\n
\n9 IBM zSeries Based Linux \nBig<\/p>\n\n\n\n
\n10 Linux IA (32-bit) \nLittle<\/p>\n\n\n\n
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT<\/p>\n\n\n\n
———– ——————————\n————–<\/p>\n\n\n\n
\n11 Linux IA (64-bit) \nLittle<\/p>\n\n\n\n
\n13 Linux x86 64-bit \nLittle<\/p>\n\n\n\n
\n7 Microsoft Windows IA (32-bit) \nLittle<\/p>\n\n\n\n
\n8 Microsoft Windows IA (64-bit) \nLittle<\/p>\n\n\n\n
\n12 Microsoft Windows x86 64-bit \nLittle<\/p>\n\n\n\n
\n17 Solaris Operating System (x86) Little<\/p>\n\n\n\n
\n20 Solaris Operating System (x86- Little<\/p>\n\n\n\n
\n64)<\/p>\n\n\n\n
\n1 Solaris[tm] OE (32-bit) \nBig<\/p>\n\n\n\n
\n2 Solaris[tm] OE (64-bit) \nBig<\/p>\n\n\n\n
20 rows selected.<\/p>\n\n\n\n
\u68c0\u67e5\u8868\u7a7a\u95f4\u662f\u5426\u81ea\u5305\u542b \u63a8\u8350\u9605\u8bfb\uff1aOGG\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e<\/a><\/p>\n\n\n\n SQL> exec\ndbms_tts.transport_set_check(‘RCAT’, incl_constraints=>true,\nfull_check=>true);<\/p>\n\n\n\n PL\/SQL procedure successfully completed.<\/p>\n\n\n\n SQL> select * from\ntransport_set_violations;<\/p>\n\n\n\n no rows selected<\/p>\n\n\n\n \u8fd9\u91cc\u7684\u8868\u6ca1\u6709\u6570\u636e\uff0c\u53ef\u89c1\u662f\u8be5\u8868\u7a7a\u95f4\u662f\u81ea\u5305\u542b\u7684\u3002<\/p>\n\n\n\n 2\u3001\u5c06\u8868\u7a7a\u95f4\u7684\u72b6\u6001\u6539\u4e3a\u53ea\u8bfb<\/p>\n\n\n\n SQL> alter tablespace rcat read only;<\/p>\n\n\n\n Tablespace altered.<\/p>\n\n\n\n 3\u3001\u8fdb\u884c\u8868\u7a7a\u95f4\u5bfc\u51fa<\/p>\n\n\n\n [oracle@LINFAN2~]$ expdp system\ndirectory=DATA_PUMP_DIR dumpfile=cs_rcat.dmp logfile=tts_rcat.log\ntransport_tablespaces=rcat transport_full_check=y<\/p>\n\n\n\n Export: Release 11.2.0.3.0 – Production on\nThu Feb 23 16:13:18 2017<\/p>\n\n\n\n Copyright (c) 1982, 2011, Oracle and\/or its\naffiliates. All rights reserved.<\/p>\n\n\n\n Password: oracle<\/p>\n\n\n\n \u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002<\/p>\n\n\n\n Job\n“SYSTEM”.”SYS_EXPORT_TRANSPORTABLE_01″ successfully\ncompleted at 16:14:12<\/p>\n\n\n\n \u5bfc\u51fa\u6210\u529f<\/p>\n\n\n\n 4\u3001\u5c06\u5bfc\u51fa\u7684\u6587\u4ef6\u4f20\u9001\u5230\u53e6\u4e00\u4e2a\u5e73\u53f0\u4e0a<\/p>\n\n\n\n [oracle@LINFAN2 ~]$ scp\n\/u01\/app\/oracle\/admin\/TOMATO\/dpdump\/cs_rcat.dmp\nodd:\/u01\/app\/oracle\/admin\/POTATO\/dpdump\/<\/p>\n\n\n\n oracle@linfan’s password:<\/p>\n\n\n\n tts_rcat.dmp 100%\n1864KB 1.8MB\/s 00:00 \n<\/p>\n\n\n\n [oracle@EVEN ~]$ scp\n\/u01\/app\/oracle\/oradata\/TOMATO\/rcat.dbf odd:\/u01\/app\/oracle\/POTATO\/oradata<\/p>\n\n\n\n oracle@linfan’s password:<\/p>\n\n\n\n rcat.dbf 100% 113MB \n22.6MB\/s 00:05<\/p>\n\n\n\n \u5bfc\u51fa\u5b8c\u5c31\u53ef\u4ee5\u628a\u8868\u7a7a\u95f4\u6539\u4e3a\u8bfb\u5199\u6a21\u5f0f\u4e86<\/p>\n\n\n\n SQL> alter tablespace rcat read write;<\/p>\n\n\n\n Tablespace altered.<\/p>\n\n\n\n 5\u3001\u5efa\u7acbrman\u7528\u6237\uff0c\u5e76\u8d4b\u4e88\u6743\u9650<\/p>\n\n\n\n SQL> create user rman identified by\nrman;<\/p>\n\n\n\n User created.<\/p>\n\n\n\n SQL> grant connect, resource to rman;<\/p>\n\n\n\n Grant succeeded.<\/p>\n\n\n\n 6\u3001\u5f00\u59cb\u4f20\u8f93 <\/p>\n\n\n\n oracle@odd-LINFAN ~]$ impdp system directory=data_pump_dir dumpfile=tts_rcat.dmp logfile=cs_import.log transport_datafiles=\/u01\/app\/oracle\/oradata\/POTATO\/rcat.dbf \u66f4\u591a\u5185\u5bb9\u8bf7\u9605\u8bfb\uff1aCPANEL\u4e0eWHM\u7684\u533a\u522b<\/a><\/p>\n\n\n\n Import: Release 11.2.0.3.0 – Production on\nThu Feb 23 16:38:52 2017<\/p>\n\n\n\n Copyright (c) 1982, 2011, Oracle and\/or its\naffiliates. All rights reserved.<\/p>\n\n\n\n Password:<\/p>\n\n\n\n \u3002\u3002\u3002\u3002\u3002\u3002\u3002\u3002<\/p>\n\n\n\n ORA-39082: Object type TRIGGER:”RMAN”.”SCRL_TRIGGER”\ncreated with compilation warnings<\/p>\n\n\n\n Processing object type\nTRANSPORTABLE_EXPORT\/POST_INSTANCE\/PLUGTS_BLK<\/p>\n\n\n\n Job\n“SYSTEM”.”SYS_IMPORT_TRANSPORTABLE_01″ completed with 4\nerror(s) at 16:39:13<\/p>\n\n\n\n \u5b8c\u6210\u5bfc\u5165\uff0c\u8fd9\u91cc\u62a5\u7684\u51e0\u4e2awaring\u662f\u56e0\u4e3a\u89e6\u53d1\u5668\u6ca1\u6709\u51fa\u9001\u8fc7\u6765<\/p>\n\n\n\n 7\u3001\u68c0\u67e5\u6570\u636e\u662f\u5426\u4f20\u9001\u8fc7\u6765\u4e86<\/p>\n\n\n\n SQL> select count(1) from rman.bp;<\/p>\n\n\n\n \nCOUNT(1)<\/p>\n\n\n\n ———-<\/p>\n\n\n\n \n11<\/p>\n\n\n\n \u81ea\u6b64\uff0c\u4f20\u8f93\u5e76\u5c06\u7b97\u662f\u5b8c\u6210\u4e86 \u63a8\u8350\u9605\u8bfb\uff1aORACLE 11G \u8868\u7a7a\u95f4\u52a0\u5bc6<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" \u4e00\u3001\u4f20\u8f93\u8868\u7a7a\u95f4\u6982\u8ff0 \u5728Oracle\u73af\u5883\u4e2d\uff0c\u6709\u5f88\u591a\u65b9\u6cd5\u53ef\u4ee5\u5bf9\u6570\u636e\u8fdb\u884c\u5907\u4efd\u548c\u4f20\u8f93\uff0c\u50cf\u662fexp\/imp\u3001e… \u7ee7\u7eed\u9605\u8bfb Oracle\u4f20\u8f93\u8868\u7a7a\u95f4<\/span><\/i><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[158],"aioseo_notices":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/posts\/1022"}],"collection":[{"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/comments?post=1022"}],"version-history":[{"count":1,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/posts\/1022\/revisions"}],"predecessor-version":[{"id":1023,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/posts\/1022\/revisions\/1023"}],"wp:attachment":[{"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/media?parent=1022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/categories?post=1022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/tags?post=1022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}