RMAN Backup and Restore using AVAMAR

Create a flag file
(simply in a text file) with following parameter (Change paths accordingly)


--pidname=oracle
--pidnum=3002
--logfile=C:\Program Files\avs\var\avtar.log
--vardir=C:\Program Files\avs\var
--id=User                
--ap=User1
--path=/Database/Oracle/or-01.loc
--expires=60
--ddr
--ddr-index=1


For Backup run this script

run{
#configure controlfile autobackup on;
allocate channel c1 type sbt
PARMS="SBT_LIBRARY=C:\PROGRA~1\avs\bin\Libobk_avamar64.dll" format '%d_%U';
#set controlfile autobackup format for device type sbt to "cfgisdb.%F";
send '"--flagfile=C:\TEMP\FlagFileBkp.txt" "--bindir=C:\PROGRA~1\avs\bin"';
backup database plus archivelog;
# restore database preview;
#restore controlfile from autobackup preview;
#restore database validate;
release channel c1;
}


For restore

Use this script (You can use validate and preview switches to just check backup pieces integrety.


run{
allocate channel c1 type sbt
PARMS="SBT_LIBRARY=C:\PROGRA~1\avs\bin\Libobk_avamar64.dll" format '%d_%U';
send '"--flagfile=C:\TEMP\FlagFileBkp.txt" "--bindir=C:\PROGRA~1\avs\bin"';
restore database;
#restore controlfile from autobackup preview;
#restore database validate;
release channel c1;
}