Database Software

I have 3 node RAC with ASM ( 11.2.0.3.0)
FRA is configured :

Backup startegey is to :
I did the following :

1) Took the 0 level cumilate backup from node 1 and backed up the backup area to TSM tape using tdpo agnet
  ( backup the database to FRA(DIsk)  and then backup the recovery area to tape.)

Backup Set Copy #2 of backup set 123456416
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  SBT_TAPE    00:02:17     29-MAR-12       YES        TAG20120329T101344

    List of Backup Pieces for backup set 123456416 Copy #2
    BP Key  Pc# Status      Media                   Piece Name
    ------- --- ----------- ----------------------- ----------
    123456743 1   AVAILABLE   9310                    34n731mp_1_2__backup


2) Tried to do a recovery from node 2 using the tdpo agent ( from tape )
But that failed :

channel c1: reading from backup piece 34n731mp_1_2__backup
channel c1: ORA-19870: error while restoring backup piece 34n731mp_1_2__backup
ORA-19507: failed to retrieve sequential file, handle="34n731mp_1_2__backup", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1302E (RC2)    No objects on server match query

failover to previous backup

creating datafile file number=8 name=+DATA/dbname/datafile/system.262.779021467
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/29/2012 10:47:03
ORA-27191: sbtinfo2 returned error
Additional information: 3474

3) Tried to a recovery for the FRA ( DISK) from node 2
It worked and database was restored.

4) Now I tried to do arecovery from node 1 using TSM TPDO agnet ( from tape tape)
It worked.

channel c1: restoring datafile 00007 to +DATA/dba_name/datafile/voltage_ts.271.774289029
channel c1: restoring datafile 00008 to +DATA/dba_name/datafile/system.262.779021467
channel c1: reading from backup piece 34n731mp_1_2__backup
channel c1: piece handle=34n731mp_1_2__backup tag=TAG20120329T101344
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:06:06
Finished restore at 29-MAR-12
released channel: c1

So I belive the node 2 tdpo is not able to pick the backup peice from the TSM , eventhough RMAN identifeis there is an backup take to the tape.
But node 2 can restore/recover from the FRA eventhough the backup was taken by node 1


Please advise how can i get the backups restored from the tape with TSM (with tdpo agent)


Also I do a backup from the nodes using :

connect target /
connect ctalaog rman/rman@CATRMAN

run {
allocate channel c1 type 'sbt_tape' parms='ENV=(TDPO_OPTFILE=$TDPO_OPTFILE)' format '%U_CF_backup';
backup current controlfile;
release channel c1;
backup $type incremental level ${level} cumulative database;
allocate channel c1 device type sbt parms='ENV=(TDPO_OPTFILE=$TDPO_OPTFILE)' format '%U_${BACKUP_TYPE}_backup' MAXPIECESIZE 10G;
allocate channel c2 device type sbt parms='ENV=(TDPO_OPTFILE=$TDPO_OPTFILE)' format '%U_${BACKUP_TYPE}_backup' MAXPIECESIZE 10G;
backup recovery area;
release channel c1;
release channel c2;
}



Regards
Joe

Edited by: RACADMIN on 29-Mar-2012 05:56