I restore 2 times, both times were 2 errors. You can see the following error: ===============================================================
The first:
Starting restore at 2011-08-18 15:51:22 using target database control file instead of recovery catalog allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: sid=9778 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_2 channel ORA_SBT_TAPE_2: sid=9569 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_2: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_3 channel ORA_SBT_TAPE_3: sid=10898 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_3: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_4 channel ORA_SBT_TAPE_4: sid=9814 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_4: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_5 channel ORA_SBT_TAPE_5: sid=10557 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_5: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_6 channel ORA_SBT_TAPE_6: sid=9759 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_6: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_7 channel ORA_SBT_TAPE_7: sid=8678 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_7: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=8554 instance=oltpdb3 devtype=DISK channel ORA_SBT_TAPE_1: starting validation of datafile backupset channel ORA_SBT_TAPE_2: starting validation of datafile backupset channel ORA_SBT_TAPE_3: starting validation of datafile backupset channel ORA_SBT_TAPE_4: starting validation of datafile backupset channel ORA_SBT_TAPE_1: reading from backup piece f6mk8535_1_1 channel ORA_SBT_TAPE_2: reading from backup piece f2mk8531_1_1 channel ORA_SBT_TAPE_3: reading from backup piece fgmk8dpb_1_1 channel ORA_SBT_TAPE_4: reading from backup piece f4mk8533_1_1 ORA-19870: error reading backup piece f6mk8535_1_1 ORA-19507: failed to retrieve sequential file, handle="f6mk8535_1_1", 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 ORA-19870: error reading backup piece f2mk8531_1_1 ORA-19507: failed to retrieve sequential file, handle="f2mk8531_1_1", 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 ORA-19870: error reading backup piece fgmk8dpb_1_1 ORA-19507: failed to retrieve sequential file, handle="fgmk8dpb_1_1", 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 ORA-19870: error reading backup piece f4mk8533_1_1 ORA-19507: failed to retrieve sequential file, handle="f4mk8533_1_1", 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 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 08/18/2011 15:52:04 ORA-27191: sbtinfo2 returned error Additional information: 2 =============================================================== =============================================================== ===============================================================
The second:
Starting restore at 2011-08-31 11:19:29 using target database control file instead of recovery catalog allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: sid=9156 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_2 channel ORA_SBT_TAPE_2: sid=8607 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_2: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_3 channel ORA_SBT_TAPE_3: sid=9450 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_3: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_4 channel ORA_SBT_TAPE_4: sid=10893 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_4: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_5 channel ORA_SBT_TAPE_5: sid=10192 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_5: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_6 channel ORA_SBT_TAPE_6: sid=10051 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_6: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_7 channel ORA_SBT_TAPE_7: sid=9597 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_7: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=8403 instance=oltpdb3 devtype=DISK channel ORA_SBT_TAPE_1: starting validation of datafile backupset channel ORA_SBT_TAPE_2: starting validation of datafile backupset channel ORA_SBT_TAPE_3: starting validation of datafile backupset channel ORA_SBT_TAPE_4: starting validation of datafile backupset channel ORA_SBT_TAPE_5: starting validation of datafile backupset channel ORA_SBT_TAPE_1: reading from backup piece ujml55c4_1_1 channel ORA_SBT_TAPE_2: reading from backup piece uiml55c2_1_1 channel ORA_SBT_TAPE_3: reading from backup piece uhml55c1_1_1 channel ORA_SBT_TAPE_4: reading from backup piece v2ml5i2j_1_1 channel ORA_SBT_TAPE_5: reading from backup piece v9ml5nfl_1_1 ;; ORA-19870: error reading backup piece ujml55c4_1_1 ORA-19507: failed to retrieve sequential file, handle="ujml55c4_1_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: ANS1235E (RC-72) An unknown system error has occurred from which TSM cannot recover. ORA-19870: error reading backup piece v2ml5i2j_1_1 ORA-19507: failed to retrieve sequential file, handle="v2ml5i2j_1_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: ANS1235E (RC-72) An unknown system error has occurred from which TSM cannot recover.
You know what this error, help me. Thanks!
The first:
Starting restore at 2011-08-18 15:51:22 using target database control file instead of recovery catalog allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: sid=9778 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_2 channel ORA_SBT_TAPE_2: sid=9569 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_2: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_3 channel ORA_SBT_TAPE_3: sid=10898 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_3: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_4 channel ORA_SBT_TAPE_4: sid=9814 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_4: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_5 channel ORA_SBT_TAPE_5: sid=10557 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_5: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_6 channel ORA_SBT_TAPE_6: sid=9759 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_6: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_7 channel ORA_SBT_TAPE_7: sid=8678 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_7: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=8554 instance=oltpdb3 devtype=DISK channel ORA_SBT_TAPE_1: starting validation of datafile backupset channel ORA_SBT_TAPE_2: starting validation of datafile backupset channel ORA_SBT_TAPE_3: starting validation of datafile backupset channel ORA_SBT_TAPE_4: starting validation of datafile backupset channel ORA_SBT_TAPE_1: reading from backup piece f6mk8535_1_1 channel ORA_SBT_TAPE_2: reading from backup piece f2mk8531_1_1 channel ORA_SBT_TAPE_3: reading from backup piece fgmk8dpb_1_1 channel ORA_SBT_TAPE_4: reading from backup piece f4mk8533_1_1 ORA-19870: error reading backup piece f6mk8535_1_1 ORA-19507: failed to retrieve sequential file, handle="f6mk8535_1_1", 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 ORA-19870: error reading backup piece f2mk8531_1_1 ORA-19507: failed to retrieve sequential file, handle="f2mk8531_1_1", 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 ORA-19870: error reading backup piece fgmk8dpb_1_1 ORA-19507: failed to retrieve sequential file, handle="fgmk8dpb_1_1", 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 ORA-19870: error reading backup piece f4mk8533_1_1 ORA-19507: failed to retrieve sequential file, handle="f4mk8533_1_1", 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 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 08/18/2011 15:52:04 ORA-27191: sbtinfo2 returned error Additional information: 2 =============================================================== =============================================================== ===============================================================
The second:
Starting restore at 2011-08-31 11:19:29 using target database control file instead of recovery catalog allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: sid=9156 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_2 channel ORA_SBT_TAPE_2: sid=8607 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_2: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_3 channel ORA_SBT_TAPE_3: sid=9450 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_3: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_4 channel ORA_SBT_TAPE_4: sid=10893 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_4: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_5 channel ORA_SBT_TAPE_5: sid=10192 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_5: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_6 channel ORA_SBT_TAPE_6: sid=10051 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_6: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_SBT_TAPE_7 channel ORA_SBT_TAPE_7: sid=9597 instance=oltpdb3 devtype=SBT_TAPE channel ORA_SBT_TAPE_7: Data Protection for Oracle: version 5.4.1.0 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=8403 instance=oltpdb3 devtype=DISK channel ORA_SBT_TAPE_1: starting validation of datafile backupset channel ORA_SBT_TAPE_2: starting validation of datafile backupset channel ORA_SBT_TAPE_3: starting validation of datafile backupset channel ORA_SBT_TAPE_4: starting validation of datafile backupset channel ORA_SBT_TAPE_5: starting validation of datafile backupset channel ORA_SBT_TAPE_1: reading from backup piece ujml55c4_1_1 channel ORA_SBT_TAPE_2: reading from backup piece uiml55c2_1_1 channel ORA_SBT_TAPE_3: reading from backup piece uhml55c1_1_1 channel ORA_SBT_TAPE_4: reading from backup piece v2ml5i2j_1_1 channel ORA_SBT_TAPE_5: reading from backup piece v9ml5nfl_1_1 ;; ORA-19870: error reading backup piece ujml55c4_1_1 ORA-19507: failed to retrieve sequential file, handle="ujml55c4_1_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: ANS1235E (RC-72) An unknown system error has occurred from which TSM cannot recover. ORA-19870: error reading backup piece v2ml5i2j_1_1 ORA-19507: failed to retrieve sequential file, handle="v2ml5i2j_1_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: ANS1235E (RC-72) An unknown system error has occurred from which TSM cannot recover.
You know what this error, help me. Thanks!
