Thursday, November 3, 2016
[oracle@ora12c ~]$ more incrconvert.sql
DECLARE
d varchar2(512);
h varchar2(512) ;
t varchar2(30) ;
b1 boolean ;
b2 boolean ;
outhandle varchar2(512) ;
outtag varchar2(30) ;
done boolean ;
failover boolean ;
devtype VARCHAR2(512);
BEGIN
d := sys.dbms_backup_restore.deviceAllocate;
sys.dbms_backup_restore.applysetdatafile(check_logical=>false, cleanup=>false);
sys.dbms_backup_restore.applyDatafileTo(
dfnumber=>6,
toname =>'+DATA/ORA12C/DATAFILE/mybigts.280.926495409',
fuzziness_hint=>0,
max_corrupt =>0,
islevel0=>0,
recid=>0,
stamp=>0);
sys.dbms_backup_restore.restoreSetPiece(
handle=>'/tmp/11g_xtts/incr/mybigts_incr_final_0drjjc4m_1_1',
tag=>null,
fromdisk=>true,
recid=>0,
stamp=>0);
sys.dbms_backup_restore.restoreBackupPiece(
done=>done,
params=>null,
outhandle=>outhandle,
outtag=>outtag,
failover=>failover);
sys.dbms_backup_restore.restoreCancel(TRUE);
sys.dbms_backup_restore.deviceDeallocate;
END;
/