The fact that you can see the previous backup pieces in Avamar suggest they are already present in Avamar.
But you cannot just recover a single backup piece via RMAN unless it contains the entire DB and its associated control file which is not normally the case.
Normally one would perform a recovery of the required control file for which you would need to know its name via RMAN and from there recover the DB.
I suggest you open a support case so they can walk you through this process.
Manual RMAN recoveries are documented in the Avamar Oracle plug-in guide.
You are correct Adam in that the backup pieces are in Avamar, but the problem is that the RMAN catalog and controlfile don't know about all of them. We had a situation where the retention policy was somehow set back to redundancy 1, so Oracle only knows about the last day's backups. I'm trying to catalog the older backup pieces in Avamar so Oracle will know about them again.
I found Oracle Doc ID 550082.1 and am trying to get that to work but get the following error:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so, ENV=(PATH=/usr/local/avamar/bin,FLAGFILE=/oracle/local/common/rman/my-avtar-flags.txt)";
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
catalog device type 'sbt_tape' backupset 'LAWP_609_1_821140803_bk.rman';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
ORA-19870: error while restoring backup piece LAWP_609_1_821140803_bk.rman
ORA-19608: LAWP_609_1_821140803_bk.rman is not a backup piece
ORA-19837: invalid blocksize 0 in backup piece header
mradamk
215 Posts
0
July 24th, 2013 12:00
Steve,
The fact that you can see the previous backup pieces in Avamar suggest they are already present in Avamar.
But you cannot just recover a single backup piece via RMAN unless it contains the entire DB and its associated control file which is not normally the case.
Normally one would perform a recovery of the required control file for which you would need to know its name via RMAN and from there recover the DB.
I suggest you open a support case so they can walk you through this process.
Manual RMAN recoveries are documented in the Avamar Oracle plug-in guide.
regards,
Adam
SteveGivens1
3 Posts
0
July 25th, 2013 12:00
You are correct Adam in that the backup pieces are in Avamar, but the problem is that the RMAN catalog and controlfile don't know about all of them. We had a situation where the retention policy was somehow set back to redundancy 1, so Oracle only knows about the last day's backups. I'm trying to catalog the older backup pieces in Avamar so Oracle will know about them again.
I found Oracle Doc ID 550082.1 and am trying to get that to work but get the following error:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE'
PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so,
ENV=(PATH=/usr/local/avamar/bin,FLAGFILE=/oracle/local/common/rman/my-avtar-flags.txt)";
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
catalog device type 'sbt_tape' backupset 'LAWP_609_1_821140803_bk.rman';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;
ORA-19870: error while restoring backup piece LAWP_609_1_821140803_bk.rman
ORA-19608: LAWP_609_1_821140803_bk.rman is not a backup piece
ORA-19837: invalid blocksize 0 in backup piece header
oskargralinski
1 Message
0
September 1st, 2014 23:00
Hi Steve,
do you resolve your problem? I have the same issue, i need catalog some file from avamar because i have any older version of controlfile.
Thanks in advice
Oskar