As root user in Target Node:
Step 1 :
/usr/local/avamar/bin/avtar –backups –flagfile=/var/avamar/scripts/my-avtar-flags.txt
Make a note of recent Seq in our case it is 124980 .
Step 2 :
/usr/local/avamar/bin/avtar –list –sequencenumber=124980 –flagfile=/var/avamar/scripts/my-avtar-flags.txt
Get the control file name using above command.
In our case “11g/PROD/CONTROLFILE.PROD.c-193295451-20170128-00”
As Oracle user in Target Node:
Step 3 :
Step 4 :
Create a pfile with db_name=PROD.
Step 5 :
Start the database in nomount.
SQL> startup nomount pfile=’initPROD.ora’;
Step 6 :
Connect Rman and execute below command
RMAN > set DBID=193295451;
run{
allocate channel c0 type sbt PARMS=”SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so” format ‘%d_%U’;
send ‘”–prefix=11g/PROD/” “–flagfile=/var/avamar/scripts/my-avtar-flags.txt” “–bindir=/usr/local/avamar/bin” “–sysdir=/usr/local/avamar/etc”‘;
restore controlfile from ‘CONTROLFILE.PROD.c-193295451-20170128-00’;
}
#### Control file taken from step 2.
Step 7 :
SQL> alter database mount;
Step 8:
RMAN> list backup;
Take recent LOW SCN number.
181267677438
Step 9 :
Connect rman and execute the below command.
run
{
allocate channel c0 type sbt PARMS=”SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so” format ‘%d_%U’;
send ‘”–prefix=11g/PROD/” “–flagfile=/var/avamar/scripts/my-avtar-flags.txt” “–bindir=/usr/local/avamar/bin” “–sysdir=/usr/local/avamar/etc”‘;
SET NEWNAME FOR DATABASE TO ‘/development/oracle/Development/db/apps_st/data/%b’;
set until scn 181267677438;
restore database;
switch datafile all;
recover database;
release channel c0;
}
