hi,
list backup of archive log tell me I have archive 36871
when I try to restore it, it is not found
how is it possible ?
Thanks for your help
(11.2.0.2)
RMAN-03090: Starting restore at 18/10/2014 19:30
DBGANY: trying implicit resync before compiling command restore [19:30:13.475]
DBGANY: Perform setDatabase for dbms_rcvcat [19:30:13.509] (krmksetdb)
DBGANY: kx->oam_tst_level=0 [19:30:13.524] (krmksetdb)
DBGANY: kx->is_am_schema=0 [19:30:13.524] (krmksetdb)
DBGANY: performing implicit partial resync of recovery catalog (restore) [19:30:13.813]
DBGANY: No untilscn in effect [19:30:13.814] (krmkicat)
DBGANY: RESYNCINC... [19:30:13.829] (krmicomp)
DBGANY: No untilscn in effect [19:30:15.440] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=258 device type=DISK
DBGANY: No untilscn in effect [19:30:15.620] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_2
RMAN-08500: channel ORA_DISK_2: SID=322 device type=DISK
DBGANY: No untilscn in effect [19:30:15.813] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_3
RMAN-08500: channel ORA_DISK_3: SID=386 device type=DISK
DBGANY: No untilscn in effect [19:30:16.021] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_4
RMAN-08500: channel ORA_DISK_4: SID=450 device type=DISK
DBGANY: No untilscn in effect [19:30:16.215] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_5
RMAN-08500: channel ORA_DISK_5: SID=514 device type=DISK
DBGANY: No untilscn in effect [19:30:16.395] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_6
RMAN-08500: channel ORA_DISK_6: SID=578 device type=DISK
DBGANY: No untilscn in effect [19:30:16.579] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_7
RMAN-08500: channel ORA_DISK_7: SID=642 device type=DISK
DBGANY: No untilscn in effect [19:30:16.759] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_8
RMAN-08500: channel ORA_DISK_8: SID=706 device type=DISK
DBGANY: No untilscn in effect [19:30:16.947] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_9
RMAN-08500: channel ORA_DISK_9: SID=770 device type=DISK
DBGANY: No untilscn in effect [19:30:17.133] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_10
RMAN-08500: channel ORA_DISK_10: SID=834 device type=DISK
DBGANY: No untilscn in effect [19:30:17.322] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_11
RMAN-08500: channel ORA_DISK_11: SID=898 device type=DISK
DBGANY: No untilscn in effect [19:30:17.507] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_12
RMAN-08500: channel ORA_DISK_12: SID=961 device type=DISK
DBGANY: No untilscn in effect [19:30:17.701] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_13
RMAN-08500: channel ORA_DISK_13: SID=1026 device type=DISK
DBGANY: No untilscn in effect [19:30:17.889] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_14
RMAN-08500: channel ORA_DISK_14: SID=1091 device type=DISK
DBGANY: No untilscn in effect [19:30:18.085] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_15
RMAN-08500: channel ORA_DISK_15: SID=1154 device type=DISK
DBGANY: No untilscn in effect [19:30:18.289] (krmkicat)
RMAN-08030: allocated channel: ORA_DISK_16
RMAN-08500: channel ORA_DISK_16: SID=1217 device type=DISK
DBGANY: No untilscn in effect [19:30:18.486] (krmkicat)
RMAN-08030: allocated channel: ORA_SBT_TAPE_1
RMAN-08500: channel ORA_SBT_TAPE_1: SID=1282 device type=SBT_TAPE
RMAN-08526: channel ORA_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
DBGANY: No untilscn in effect [19:30:18.696] (krmkicat)
RMAN-08030: allocated channel: ORA_SBT_TAPE_2
RMAN-08500: channel ORA_SBT_TAPE_2: SID=1346 device type=SBT_TAPE
RMAN-08526: channel ORA_SBT_TAPE_2: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
DBGANY: No untilscn in effect [19:30:18.908] (krmkicat)
RMAN-08030: allocated channel: ORA_SBT_TAPE_3
RMAN-08500: channel ORA_SBT_TAPE_3: SID=1410 device type=SBT_TAPE
RMAN-08526: channel ORA_SBT_TAPE_3: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
DBGANY: No untilscn in effect [19:30:19.099] (krmkicat)
RMAN-08030: allocated channel: ORA_SBT_TAPE_4
RMAN-08500: channel ORA_SBT_TAPE_4: SID=1474 device type=SBT_TAPE
RMAN-08526: channel ORA_SBT_TAPE_4: Veritas NetBackup for Oracle - Release 7.0 (2010070800)
DBGANY: No untilscn in effect [19:30:19.299] (krmkicat)
DBGANY: No untilscn in effect [19:30:19.305] (krmkicat)
RMAN-08017: channel ORA_SBT_TAPE_1: starting archived log restore to default destination
DBGIO: channel ORA_SBT_TAPE_1: set_stamp=859677028 set_count=12421 [19:30:22.517] (rsal_start)
RMAN-08022: channel ORA_SBT_TAPE_1: restoring archived log
RMAN-08510: archived log thread=1 sequence=36971
RMAN-08003: channel ORA_SBT_TAPE_1: reading from backup piece LODSD_20141001_1_2_12421_859677028
RMAN-06731: command restore:4.6% complete, time left 00:44:08
RMAN-06731: command restore:13.5% complete, time left 00:26:26
RMAN-06731: command restore:22.2% complete, time left 00:21:33
RMAN-06731: command restore:30.4% complete, time left 00:18:37
RMAN-06731: command restore:37.6% complete, time left 00:16:46
RMAN-06731: command restore:45.5% complete, time left 00:14:30
RMAN-06731: command restore:52.7% complete, time left 00:12:40
RMAN-06731: command restore:61.2% complete, time left 00:10:14
RMAN-06731: command restore:69.6% complete, time left 00:07:55
RMAN-06731: command restore:77.6% complete, time left 00:05:48
RMAN-06731: command restore:81.1% complete, time left 00:05:09
RMAN-06731: command restore:84.3% complete, time left 00:04:31
RMAN-06731: command restore:85.5% complete, time left 00:04:27
RMAN-06731: command restore:86.6% complete, time left 00:04:22
RMAN-06731: command restore:87.6% complete, time left 00:04:15
RMAN-06731: command restore:91.1% complete, time left 00:03:08
RMAN-08615: channel ORA_SBT_TAPE_1: ORA-19870: error while restoring backup piece LODSD_20141001_1_2_12421_859677028
ORA-19622: archived log thread 1 sequence 36971 not restored due to missing data
RMAN-05016: failover to previous backup
DBGANY: No untilscn in effect [20:03:47.815] (krmkicat)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/18/2014 20:03:47
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 1 with sequence 36971 and starting SCN of 691222549683 found to restore
RMAN>
Recovery Manager complete.
DBGANY: No untilscn in effect [20:03:48.175] (krmkicat)
DBGANY: RESYNCINC... [20:03:48.184] (krmicomp)
==================================================================================================
RMAN> list backup of archivelog sequence 36971;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
278410469 33.55G SBT_TAPE 01:14:09 01-OCT-14
BP Key: 278410606 Status: AVAILABLE Compressed: NO Tag: INC_4_APPLY
Handle: LODSD_20141001_1_2_12421_859677028 Media: @aaacj
List of Archived Logs in backup set 278410469
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 36971 691222549683 28-SEP-14 691228598437 28-SEP-14