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