xttcnvrtbkupdest.sql

最新推荐文章于 2021-03-24 14:32:58 发布

转载最新推荐文章于 2021-03-24 14:32:58 发布 · 100 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/697301

本文介绍了一个使用Oracle DBMS_BACKUP_RESTORE包进行跨平台增量备份转换的过程。通过取消当前的还原操作，分配设备，然后备份特定的增量备份片段，最后完成备份片段的转换。

--
-- 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

  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