rman_xttconvert_v3.zip Oracle XTTS 必备工具 mos上下载的xtts迁移脚本

-- -- Convert the incremental backup (target convert) -- Inputs: cross-plaform backups -- set serveroutput on; set termout on; set verify off; DECLARE handle varchar2(512) ; comment varchar2(80) ; media varchar2(80) ; concur boolean ; recid number ; stamp number ; platfrmto number; same_endian number := 1; sql_stmt VARCHAR2(400) := 'BEGIN sys.dbms_backup_restore.applyDatafileTo( dfnumber => :b1, toname => :b2, fuzziness_hint => 0, max_corrupt => 0, islevel0 => 0, recid => 0, stamp => 0); END; '; devtype VARCHAR2(512); BEGIN BEGIN sys.dbms_backup_restore.restoreCancel(TRUE); devtype := sys.dbms_backup_restore.deviceAllocate; sys.dbms_backup_restore.backupBackupPiece( bpname => '&&1', fname => '&&2/xtts_incr_backup', 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 => &&3); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line ('ERROR IN CONVERSION ' || SQLERRM); END ; sys.dbms_backup_restore.deviceDeallocate; DBMS_OUTPUT.put_line('CONVERTED BACKUP PIECE' || '&&2/xtts_incr_backup'); END; / exit