Restore the database from AVAMAR backup
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…
Read More