xttcnvrtbkupdest.sql

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