{"id":1565,"date":"2021-12-18T17:43:13","date_gmt":"2021-12-18T09:43:13","guid":{"rendered":"http:\/\/www.821121.com\/?p=1565"},"modified":"2022-01-04T11:06:52","modified_gmt":"2022-01-04T03:06:52","slug":"11g%e5%8d%87%e7%ba%a719c%e4%bd%bf%e7%94%a8xtts-%e6%89%8b%e5%b7%a5%e8%bf%81%e7%a7%bb%e7%9a%84%e5%85%b3%e9%94%ae%e6%ad%a5%e9%aa%a4","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1565","title":{"rendered":"11g\u5347\u7ea719c\u4f7f\u7528XTTS \u624b\u5de5\u8fc1\u79fb\u7684\u5173\u952e\u6b65\u9aa4"},"content":{"rendered":"

1. \u67e5\u8be2\u5f00\u59cb\u7684scn<\/h3>\n
SELECT TO_CHAR(MIN(start_scn) ) AS SCN FROM gv$transaction UNION ALL SELECT TO_CHAR(current_scn) FROM gv$database;<\/code><\/pre>\n
2. backup copy<\/h3>\n
select 'backup as copy datafile ' ||file_id||' format ''\/u01\/media\/datafile\/' || tablespace_name||'_'||file_id||''';' from  dba_data_files where tablespace_name not in ('SYSTEM','SYSAUX','UNDOTBS1','UNDOTBS2') ;<\/code><\/pre>\n
3\uff0erman convert<\/h3>\n
sql\u6e90\u7aef\u6267\u884c<\/p>\n
set heanding off\nset linesize 2000\nselect 'convert from platform ''AIX-Based Systems (64-bit)'' datafile ''\/u01\/media\/datafile\/'   \n|| tablespace_name||'_'||file_id||''''|| ' format ''+DATA\/RACDB\/DATAFILE\/' \n ||  tablespace_name||'_'||file_id||'.dbf;' \nfrom dba_data_files where tablespace_name not in ('SYSTEM','SYSAUX','UNDOTBS1','UNDOTBS2'); <\/code><\/pre>\n
\u6b65\u9aa42\u7684\u6587\u4ef6\u548c\u6b65\u9aa43\u751f\u6210\u7684\u811a\u672c\u4f20\u8f93\u5230\u76ee\u6807\u7aef\u6267\u884c<\/p>\n
4\uff0e\u8bb0\u5f55scn<\/h3>\n
SELECT TO_CHAR(MIN(start_scn) ) AS "Please select the minimum SCN" FROM gv$transaction\nUNION ALL\nSELECT TO_CHAR(current_scn) FROM gv$database;<\/code><\/pre>\n
5\uff0e\u5907\u4efd\u589e\u91cf\u5907\u4efd<\/h3>\n
run{\nallocate channel c1 device type disk;  \nset until scn=TTTTT;\nbackup incremental from scn xxxx datafile 5,6,7,8  \nformat '\/u01\/media\/tablespace_incr_1';\nrelease channel c1;\n}<\/code><\/pre>\n
xxxx\u4e3arman copy\u65f6\u7684 scn\uff0cTTTTT\u4e3a\u5f53\u524d\u7684SCN<\/p>\n
6\uff0e\u589e\u91cfconvert<\/h3>\n
\u76ee\u6807\u7aef\u6267\u884c<\/p>\n
set timing on \nspool incr_conv1.log\nDECLARE \n   handle    varchar2(512); \n   comment   varchar2(80); \n   media     varchar2(80); \n   concur    boolean; \n   recid     number; \n   stamp     number; \n   pltfrmfr number; \n   devtype   VARCHAR2(512); \nBEGIN\n\n   sys.dbms_backup_restore.restoreCancel(TRUE);\n   devtype := sys.dbms_backup_restore.deviceAllocate;\n   sys.dbms_backup_restore.backupBackupPiece(bpname => '\/mnt\/xtts\/datafile_inc\/tablespace_incr_1,fname => '\/mnt\/xtts\/datafile_inc\/tablespace_incr_1_con',handle => handle,media=> media,comment=> comment, concur=> concur,recid=> recid,stamp => stamp, check_logical => FALSE,copyno=> 1, deffmt=> 0, copy_recid=> 0,copy_stamp => 0,npieces=> 1,dest=> 0,pltfrmfr=>xxx);\nEND;\n\/<\/code><\/pre>\n
xxxx\u4e3a\u4f20\u8f93\u5230\u76ee\u6807\u7aef\u7684\u589e\u91cf\u5907\u4efd\u6587\u4ef6\u540d\u79f0
\npltfrmfr=>\u6e90\u7aef\u5e73\u53f0ID<\/p>\n
7\uff0e\u5e94\u7528convert\u540e\u7684\u589e\u91cf\u5907\u4efd<\/h3>\n
\u76ee\u6807\u6570\u636e\u5e93\u9700\u8981\u5728nomount\u72b6\u6001\u4e0b<\/p>\n
set timing on \nset serveroutput on; \nspool apply_incr1.log \nDECLARE \n   outhandle varchar2(512); \n   outtag varchar2(30); \n   done boolean; \n   failover boolean; \n   devtype VARCHAR2(512); \nBEGIN \n   DBMS_OUTPUT.put_line('Entering RollForward'); \n   -- Now the rolling forward. \n   devtype := sys.dbms_backup_restore.deviceAllocate; \n   sys.dbms_backup_restore.applySetDatafile(check_logical => FALSE, cleanup => FALSE);\n   DBMS_OUTPUT.put_line('After applySetDataFile'); \n--USR_ARC_IDX,USR_ACC_TBS,EPMGIS_TB,WIPTBS\n------------------------------------------------\n--USR_ARC_IDX(106)\nsys.dbms_backup_restore.applyDatafileTo(dfnumber=>253,toname=>'+DATA\/RACDB\/DATAFILE\/Udbis_253.dbf',fuzziness_hint=>0,max_corrupt=>0,islevel0=>0,recid=>0,stamp=>0);\n   DBMS_OUTPUT.put_line('Done: applyDataFileTo'); \n   DBMS_OUTPUT.put_line('Done: applyDataFileTo'); \n   -- Restore Set Piece \n   sys.dbms_backup_restore.restoreSetPiece(handle => '\/mnt\/xtts\/datafile_inc\/tablespace_incr_1_con',tag => null, fromdisk => true, recid => 0, stamp => 0); \n   DBMS_OUTPUT.put_line('Done: RestoreSetPiece'); \n   -- Restore Backup Piece \n   sys.dbms_backup_restore.restoreBackupPiece(done => done, params => null, outhandle => outhandle,outtag => outtag, failover => failover); \n   DBMS_OUTPUT.put_line('Done: RestoreBackupPiece'); \n   sys.dbms_backup_restore.restoreCancel(TRUE); \n   sys.dbms_backup_restore.deviceDeallocate; \nEND; \n\/<\/code><\/pre>\n
8\uff0e\u53ef\u591a\u6b21\u91cd\u590d4,5,6,7\u6b65<\/h3>\n","protected":false},"excerpt":{"rendered":"
1. \u67e5\u8be2\u5f00\u59cb\u7684scn SELECT TO_CHA<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,49,37,51],"tags":[],"class_list":["post-1565","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category-oracle-19c","category--oracle-11g","category--oracle-19c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1565","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1565"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1565\/revisions"}],"predecessor-version":[{"id":1566,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1565\/revisions\/1566"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1565"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}