{"id":534,"date":"2015-06-05T17:26:10","date_gmt":"2015-06-05T09:26:10","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=534"},"modified":"2015-09-09T21:48:12","modified_gmt":"2015-09-09T13:48:12","slug":"%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba%e5%b7%a5%e5%85%b703-%e5%8f%af%e4%bc%a0%e8%be%93%e8%a1%a8%e7%a9%ba%e9%97%b4","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=534","title":{"rendered":"\u5bfc\u5165\u5bfc\u51fa\u5de5\u517703–\u53ef\u4f20\u8f93\u8868\u7a7a\u95f4"},"content":{"rendered":"
\u53ef\u4f20\u8f93\u8868\u7a7a\u95f4<\/div>\n
\n
    \n
  1. \u7528\u9014:\n
      \n
    1. \u7528\u4e8e\u4e0d\u540c\u5e73\u53f0\u7684\u6570\u636e\u8fc1\u79fb;<\/li>\n
    2. \u7528\u4e8e\u4e0d\u540c\u7248\u672c\u6570\u636e\u5e93\u4e4b\u95f4\u7684\u8fc1\u79fb;<\/li>\n<\/ol>\n<\/li>\n
    3. \u9650\u5236:\n
        \n
      1. \u4e0d\u652f\u6301XMLSchema\u7c7b\u578b\u7684\u6570\u636e;<\/li>\n
      2. \u53ea\u662f\u628a\u8868\u7a7a\u95f4\u4e0a\u7684\u6570\u636e\u4f20\u8f93\u5230\u76ee\u6807,\u7528\u6237\u7684\u5bf9\u8c61(\u5e8f\u5217,\u89c6\u56fe,\u5305,\u8fc7\u7a0b,\u89e6\u53d1\u5668)\u9700\u8981\u624b\u52a8\u521b\u5efa<\/li>\n<\/ol>\n<\/li>\n
      3. \u5b9e\u9a8c\u76ee\u6807:\u521b\u5efa\u6d4b\u8bd5\u8868\u7a7a\u95f4TBS_TT1,\u5e76\u4f20\u8f93\u5230\u76ee\u6807\u670d\u52a1\u5668;<\/li>\n
      4. \u68c0\u67e5\u662f\u5426\u6ee1\u8db3\u8868\u7a7a\u95f4\u4f20\u8f93\u7684\u6761\u4ef6:\n
          \n
        1. \u67e5\u770b\u53ef\u4f20\u8f93\u8868\u7a7a\u95f4\u652f\u6301\u6570\u636e\u5e93\u5e73\u53f0\u548c\u5f53\u524d\u6570\u636e\u5e93\u7684\u7248\u672c; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"\"\"<\/li>\n
        2. \u67e5\u770b\u8981\u4f20\u8f93\u7684\u8868\u7a7a\u95f4\u96c6\u662f\u5426\u662f\u81ea\u5305\u542b\u7684:\n
            \n
          1. \u5982\u679c\u67d0\u4e2a\u8868\u7a7a\u95f4\u96c6\u5f15\u7528\u4e86\u5176\u4ed6\u8868\u7a7a\u95f4\u7684\u5bf9\u8c61,\u5219\u8fd9\u4e2a\u8868\u7a7a\u95f4\u4e0d\u662f\u81ea\u5305\u542b\u7684,\u5426\u5219\u5c31\u662f\u81ea\u5305\u542b;<\/li>\n
          2. \u53ea\u6709\u81ea\u5305\u542b\u7684\u8868\u7a7a\u95f4\u96c6\u624d\u53ef\u4ee5\u7528\u4f20\u8f93\u8868\u7a7a\u95f4\u6280\u672f;<\/li>\n
          3. \u4f7f\u7528dbms_tts.transport_set_check\u6765\u9a8c\u8bc1\u8868\u7a7a\u95f4\u662f\u5426\u662f\u81ea\u5305\u542b\u7684,\u8981\u628a\u9700\u8981\u8868\u7a7a\u95f4\u4f20\u8f93\u7684\u8868\u7a7a\u95f4\u5217\u8868\u90fd\u5199\u4e0a,\u4e2d\u95f4\u7528\u9017\u53f7\u5206\u5272;<\/li>\n
          4. TRANSPORT_SET_VIOLATIONS\u8868\u662f\u4e00\u4e2a\u4e34\u65f6\u8868,\u5fc5\u987b\u5728\u6267\u884cdbms_tts.transport_set_check\u7684session\u4e2d\u67e5\u770b,\u5982\u679c\u6709\u8bb0\u5f55\u8fd4\u56de,\u5219\u8868\u793a\u8868\u7a7a\u95f4\u96c6\u4e0d\u662f\u81ea\u5305\u542b\u7684;<\/li>\n
          5. \u68c0\u67e5\u7684\u7ed3\u679c; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
          6. \u67e5\u770b\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
          7. \u5728\u6e90\u6570\u636e\u5e93\u5bfc\u51fa\u8868\u7a7a\u95f4;\n
              \n
            1. \u521b\u5efa\u76ee\u5f55\u5bf9\u8c61:CREATE DIRECTORY dir_tt AS ‘\/u01\/tt’; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n
            2. \u628a\u5bf9\u5e94\u7684\u8868\u7a7a\u95f4\u8bbe\u7f6e\u4e3a\u53ea\u8bfb\u6a21\u5f0f:ALTER TABLESPACE tbs_tt1 READ ONLY; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
            3. \u4f7f\u7528\u6570\u636e\u6cf5\u5bfc\u51fa,\u53ea\u662f\u5bfc\u51fa\u8868\u7a7a\u95f4\u7684\u5143\u4fe1\u606f:expdp \\’sys\/oracle as sysdba\\’ directory=dir_tt transport_tablespaces=tbs_tt1 dumpfile=tt_tbs_tt1.dmp logfile=tt.log job_name=’job_tt’; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
            4. \u8f6c\u6362\u6570\u636e\u6587\u4ef6\u683c\u5f0f:\n
                \n
              1. \u5982\u679c\u6e90\u6570\u636e\u5e93\u548c\u76ee\u6807\u6570\u636e\u5e93\u6240\u5728\u7684\u5e73\u53f0\u4e0d\u540c\u9700\u8981\u8fdb\u884c\u6b64\u6b65\u9aa4,\u628a\u8868\u7a7a\u95f4\u7684\u6570\u636e\u8f6c\u5316\u4e3a\u76ee\u6807\u5e73\u53f0\u683c\u5f0f;<\/li>\n
              2. rman\u63d0\u4f9b\u4e86\u6b64\u529f\u80fd,\u53ef\u4ee5\u5728\u6e90\u6570\u636e\u5e93\u8fdb\u884c\u4e5f\u53ef\u4ee5\u5728\u76ee\u6807\u6570\u636e\u5e93\u8fdb\u884c:\n
                  \n
                1. \u5728\u6e90\u6570\u636e\u5e93\u8f6c\u6362:convert tablespace ts1,ts2… to platform <destination platform> format ‘\/path\/%U’;<\/li>\n
                2. \u5728\u76ee\u6807\u6570\u636e\u5e93\u8f6c\u6362:convert datafile df1,df2… from platform <source platform>\u00a0format ‘\/path\/%U’;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                3. \u628a\u5bfc\u51fa\u7684\u8868\u7a7a\u95f4\u7684\u5143\u4fe1\u606f\u548c\u8868\u7a7a\u95f4\u7684\u6570\u636e\u6587\u4ef6\u4f20\u5230\u76ee\u6807\u6570\u636e\u5e93\u670d\u52a1\u5668,\u6570\u636e\u6587\u4ef6\u653e\u5230\u6570\u636e\u5e93\u7684\u76ee\u5f55\u4e0b,\u5143\u6570\u636e\u653e\u5230\u76ee\u5f55\u5bf9\u8c61\u4e0b;<\/li>\n
                4. \u4fee\u6539\u6e90\u6570\u636e\u5e93\u8868\u7a7a\u95f4\u4e3a\u8bfb\u5199\u6a21\u5f0f:ALTER TABLESPACE tbs_tt1 READ WRITE; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
                5. \u5728\u76ee\u6807\u670d\u52a1\u5668\u5bfc\u5165\u8868\u7a7a\u95f4:\n
                    \n
                  1. \u521b\u5efa\u76ee\u5f55\u5bf9\u8c61:CREATE DIRECTORY dir_tt AS ‘\/u01\/tt’; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
                  2. \u5728\u76ee\u6807\u6570\u636e\u5e93\u4e0a\u521b\u5efa\u8868\u7a7a\u95f4\u4e0a\u7684\u7528\u6237\u548c\u5e76\u6388\u4e88\u6743\u9650,\u5426\u5219\u4f1a\u62a5\u9519; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n
                  3. \u5982\u679c\u4e4b\u524d\u8fdb\u884c\u4e86\u5e73\u53f0\u7684\u8f6c\u6362\u64cd\u4f5c\u7684\u8bdd,\u6b64\u65f6\u53ef\u80fd\u9700\u8981\u4f7f\u7528rman\u5bf9\u6570\u636e\u6587\u4ef6\u8fdb\u884c\u91cd\u547d\u540d\u4e86;<\/li>\n
                  4. \u5982\u679c\u6e90\u6570\u636e\u5e93\u548c\u76ee\u6807\u6570\u636e\u5e93\u7684\u5757\u5927\u5c0f\u4e0d\u540c\u7684\u8bdd,\u9700\u8981\u5728\u76ee\u6807\u6570\u636e\u5e93\u6dfb\u52a0\u6e90\u6570\u636e\u5e93\u5757\u7684cache_size:ALTER SYSTEM SET db_4k_cache_size = 5M;<\/li>\n
                  5. \u628a\u6570\u636e\u5bfc\u5165\u5230\u76ee\u6807\u6570\u636e\u5e93\u4e2d:impdp\u00a0\\’sys\/oracle as sysdba\\’ directory=dir_tt dumpfile=tt_tbs_tt1.dmp transport_datafiles=’\/u01\/app\/oracle\/oradata\/ORCL\/tbs_tt1.dbf’ logfile= tt.log job_name=’job_tt’; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
                  6. \u4fee\u6539\u8868\u7a7a\u95f4\u4e3a\u8bfb\u5199\u6a21\u5f0f:ALTER TABLESPACE tbs_tt1 READ WRITE;(SELECT tablespace_name, status FROM dba_tablespaces WHERE tablespace_name = ‘TBS_TT1’;) \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n
                  7. \u4fee\u6539\u7528\u6237\u7684\u9ed8\u8ba4\u8868\u7a7a\u95f4:ALTER USER u1 DEFAULT TABLESPACE tbs_tt1;(SELECT username, default_tablespace FROM dba_users WHERE username = ‘U1’;) \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
                  8. \u9a8c\u8bc1\u6570\u636e;<\/li>\n<\/ol>\n<\/div>\n
                    <\/div>\n
                    — \u6d4b\u8bd5\u6570\u636e;<\/div>\n
                    — \u521b\u5efa\u8868\u7a7a\u95f4;<\/div>\n
                    CREATE TABLESPACE TBS_TT1 DATAFILE ‘\/u01\/app\/oracle\/oradata\/ORCL\/tbs_tt1.dbf’ SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
                    \n— \u521b\u5efa\u7528\u6237\u5e76\u6388\u6743;<\/div>\n
                    CREATE USER u1 IDENTIFIED BY u1 DEFAULT TABLESPACE tbs_tt1;
                    \nGRANT CONNECT, RESOURCE TO u1;
                    \n— \u521b\u5efa\u8868,\u5e8f\u5217,\u5e76\u63d2\u5165\u6d4b\u8bd5\u6570\u636e;<\/div>\n
                    CREATE TABLE u1.t1(ID INTEGER, c_lob CLOB) TABLESPACE tbs_tt1;
                    \nCREATE SEQUENCE u1.seq_t1;
                    \nINSERT INTO u1.t1(ID, c_lob) VALUES (u1.seq_t1.NEXTVAL, to_clob(‘\u4f20\u8f93\u8868\u7a7a\u95f4-\u88681\u4e2dBLOB\u5b57\u6bb5’));
                    \nCOMMIT;
                    \n— \u521b\u5efa\u89c6\u56fe;<\/div>\n
                    CREATE VIEW v_t1(ID, NAME) AS SELECT ID, to_char(c_lob) FROM u1.t1;
                    \nSELECT * FROM v_t1;
                    \n— \u521b\u5efa\u8fc7\u7a0b;<\/div>\n
                    CREATE OR REPLACE PROCEDURE pr_t1 AS
                    \nBEGIN
                    \nNULL;
                    \nEND;<\/div>\n
                    <\/div>\n
                    — \u67e5\u770b\u53ef\u4f20\u8f93\u8868\u7a7a\u95f4\u652f\u6301\u6570\u636e\u5e93\u5e73\u53f0\u548c\u5f53\u524d\u6570\u636e\u5e93\u7684\u7248\u672c;<\/div>\n
                    SELECT d.NAME, i.host_name, i.version, d.platform_name, endian_format
                    \nFROM v$transportable_platform tp, v$database d, v$instance i
                    \nWHERE tp.platform_name = d.platform_name AND\u00a0d.db_unique_name = i.instance_name;<\/div>\n
                    <\/div>\n
                    — \u67e5\u770b\u8868\u7a7a\u95f4\u662f\u5426\u662f\u81ea\u5305\u542b\u7684;<\/div>\n
                    EXECUTE dbms_tts.transport_set_check(‘TBS_TT1’, TRUE, TRUE);<\/div>\n
                    SELECT * FROM transport_set_violations;<\/div>\n
                    <\/div>\n
                    — \u67e5\u770b\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6;<\/div>\n
                    SELECT max(decode(parameter,’NLS_LANGUAGE’, VALUE, NULL)) || ‘_’ ||
                    \nmax(decode(parameter,’NLS_TERRITORY’, VALUE, NULL)) || ‘.’ ||
                    \nmax(decode(parameter,’NLS_CHARACTERSET’, VALUE, NULL)) AS “NLS_LANG”
                    \nFROM nls_database_parameters;<\/div>\n
                    <\/div>\n
                    — \u6570\u636e\u6587\u4ef6\u5e73\u53f0\u8f6c\u6362\u7684\u811a\u672c;<\/div>\n
                    RMAN> run{
                    \nallocate channel c1 device type disk connect ‘sys\/oracle@orcl_source’;
                    \nconvert tablespace example,users to platform ‘Linux IA (32-bit)’ Format ‘\/backup\/dmp\/%U’;
                    \nrelease channel c1;}<\/div>\n","protected":false},"excerpt":{"rendered":"

                    \u53ef\u4f20\u8f93\u8868\u7a7a\u95f4 \u7528\u9014: \u7528\u4e8e\u4e0d\u540c\u5e73\u53f0\u7684\u6570\u636e\u8fc1\u79fb; \u7528\u4e8e\u4e0d\u540c\u7248\u672c\u6570\u636e\u5e93\u4e4b\u95f4\u7684\u8fc1\u79fb; \u9650\u5236: \u4e0d\u652f\u6301XMLSchem […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[7,34],"class_list":["post-534","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-dw","tag-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=534"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/534\/revisions"}],"predecessor-version":[{"id":899,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/534\/revisions\/899"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}