Greetings,
We are trying to recover one archivelog from backup using TSM environment but we got an error, even this archivelog is located on the backup. Why we can’t recover this archivelog?
List archives that are necessary to recover:
CLPBDDCCS001 /home/oracle> rman target / catalog BD/xxxxxxx@rmngrprd
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Nov 24 08:34:49 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: BD (DBID=3387058822)
connected to recovery catalog database
RMAN> list backup of archivelog from logseq 16500 until logseq 16507;
starting full resync of recovery catalog
full resync complete
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -----------------------
961618 769.75M SBT_TAPE 00:01:34 19/NOV/2015 04:41:15 pm
BP Key: 961627 Status: AVAILABLE Compressed: NO Tag: BD_20151119
Handle: ARCH_DIARIO_BD_169419_1_896200781.rman Media: 3942
List of Archived Logs in backup set 961618
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ----------------------- ---------- ---------
1 16507 11329894193485 19/NOV/2015 11:39:24 am 11329894800683 19/NOV/2015 11:45:40 am
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -----------------------
962057 43.20G SBT_TAPE 05:07:59 19/NOV/2015 04:56:24 pm
BP Key: 962061 Status: AVAILABLE Compressed: NO Tag: BD_20151119
Handle: ARCH_DIARIO_BD_169414_1_896183305.rman Media: 17422
List of Archived Logs in backup set 962057
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ----------------------- ---------- ---------
1 16500 11329880920317 19/NOV/2015 10:54:30 am 11329888860123 19/NOV/2015 10:59:14 am
1 16501 11329888860123 19/NOV/2015 10:59:14 am 11329890299798 19/NOV/2015 11:03:56 am
1 16502 11329890299798 19/NOV/2015 11:03:56 am 11329891160985 19/NOV/2015 11:11:06 am
1 16503 11329891160985 19/NOV/2015 11:11:06 am 11329891749290 19/NOV/2015 11:17:39 am
1 16504 11329891749290 19/NOV/2015 11:17:39 am 11329892604268 19/NOV/2015 11:24:43 am
1 16505 11329892604268 19/NOV/2015 11:24:43 am 11329893207922 19/NOV/2015 11:30:00 am
1 16506 11329893207922 19/NOV/2015 11:30:00 am 11329894193485 19/NOV/2015 11:39:24 am
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -----------------------
962250 13.12G SBT_TAPE 00:08:51 19/NOV/2015 05:57:02 pm
BP Key: 962311 Status: AVAILABLE Compressed: NO Tag: BD_20151119
Handle: ARCH_DIARIO_BD_169423_1_896204891.rman Media: 3942
List of Archived Logs in backup set 962250
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ----------------------- ---------- ---------
1 16507 11329894193485 19/NOV/2015 11:39:24 am 11329894800683 19/NOV/2015 11:45:40 am
When we try to recover one or more archivelogs:
RMAN> run {
2> ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> set archivelog destination to '/app/oracle';
4> #restore archivelog logseq 14317;
restore archivelog from logseq 16500 until logseq 16507;
5> 6> release channel CH1;
7> }
allocated channel: CH1
channel CH1: sid=3026 devtype=SBT_TAPE
channel CH1: Data Protection for Oracle: version 7.1.0.0
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 24/NOV/2015 08:49:38 am
starting full resync of recovery catalog
full resync complete
channel CH1: starting archive log restore to user-specified destination
archive log destination=/app/oracle
channel CH1: restoring archive log
archive log thread=1 sequence=16500
channel CH1: restoring archive log
archive log thread=1 sequence=16501
channel CH1: restoring archive log
archive log thread=1 sequence=16502
channel CH1: restoring archive log
archive log thread=1 sequence=16503
channel CH1: restoring archive log
archive log thread=1 sequence=16504
channel CH1: restoring archive log
archive log thread=1 sequence=16505
channel CH1: restoring archive log
archive log thread=1 sequence=16506
channel CH1: reading from backup piece ARCH_DIARIO_BD_169414_1_896183305.rman
channel CH1: restored backup piece 1
piece handle=ARCH_DIARIO_BD_169414_1_896183305.rman tag=BD_20151119
restore not complete
Restore did not complete for archived log thread 1sequence 16506 from backup piece ARCH_DIARIO_BD_169414_1_896183305.rman (devtype=NULL, piecenum=1, pieces_done=1, done=FALSE, failover=FALSE)
channel CH1: starting archive log restore to user-specified destination
archive log destination=/app/oracle
channel CH1: restoring archive log
archive log thread=1 sequence=16507
channel CH1: reading from backup piece ARCH_DIARIO_BD_169423_1_896204891.rman
channel CH1: restored backup piece 1
piece handle=ARCH_DIARIO_BD_169423_1_896204891.rman tag=BD_20151119
restore not complete
Restore did not complete for archived log thread 1sequence 16507 from backup piece ARCH_DIARIO_BD_169423_1_896204891.rman (devtype=NULL, piecenum=1, pieces_done=1, done=FALSE, failover=FALSE)
failover to previous backup
released channel: CH1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/24/2015 09:08:59
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 16506 lowscn 11329893207922 found to restore
RMAN-06025: no backup of log thread 1 seq 16505 lowscn 11329892604268 found to restore
RMAN-06025: no backup of log thread 1 seq 16504 lowscn 11329891749290 found to restore
RMAN-06025: no backup of log thread 1 seq 16503 lowscn 11329891160985 found to restore
RMAN-06025: no backup of log thread 1 seq 16502 lowscn 11329890299798 found to restore
RMAN-06025: no backup of log thread 1 seq 16501 lowscn 11329888860123 found to restore
RMAN-06025: no backup of log thread 1 seq 16500 lowscn 11329880920317 found to restore