Re: rman strangeness

  • From: Martin Klier <usn@xxxxxxxxx>
  • To: chris_stephens@xxxxxxxxxxxx
  • Date: Mon, 02 Jun 2008 17:17:05 +0200

Hi Chris,


Stephens, Chris schrieb:
> RMAN-12009: command aborted because some backup pieces could not be located
> 
> RMAN-12008: could not locate backup piece
> /oraback1/flash_recovery_area/REMGT/backupset/2008_06_02/o1_mf_nnndf_TAG20080602T013340_4476rf8l_.bkp
> 
> RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at
> 06/02/2008 03:06:29
> 
> ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
> 
> ORA-19511: Error received from media manager layer, error text:
> 
>    VxBSAEndTxn: Failed with error:
> 
>    The transaction was aborted.
> 
> ORA-19600: input file is backup piece 
> (/oraback1/flash_recovery_area/REMGT/backupset/2008_06_02/o1_mf_nnndf_TAG20080602T013340_4476rf8l_.bkp)
> 
> ORA-19601: output file is backup piece  (91jhsnlt_1_2)
> 
> RMAN> validate backupset 87489;
> 
>  
> 
> allocated channel: ORA_SBT_TAPE_1
> 
> channel ORA_SBT_TAPE_1: sid=109 devtype=SBT_TAPE
> 
> channel ORA_SBT_TAPE_1: VERITAS NetBackup for Oracle - Release 6.0
> (2006110304)
> 
> allocated channel: ORA_SBT_TAPE_2
> 
> channel ORA_SBT_TAPE_2: sid=136 devtype=SBT_TAPE
> 
> channel ORA_SBT_TAPE_2: VERITAS NetBackup for Oracle - Release 6.0
> (2006110304)
> 
> allocated channel: ORA_DISK_1
> 
> channel ORA_DISK_1: sid=54 devtype=DISK
> 
> channel ORA_DISK_1: starting validation of datafile backupset
> 
> channel ORA_DISK_1: reading from backup piece
> /oraback1/flash_recovery_area/REMGT/backupset/2008_06_02/o1_mf_nnndf_TAG20080602T013340_4477p0db_.bkp
> 
> channel ORA_DISK_1: restored backup piece 1
> 
> piece
> handle=/oraback1/flash_recovery_area/REMGT/backupset/2008_06_02/o1_mf_nnndf_TAG20080602T013340_4477p0db_.bkp
> tag=TAG20080602T013340
> 
> channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
> 
>  
> 
> RMAN>

you have to catalog
/oraback1/flash_recovery_area/REMGT/backupset/2008_06_02/o1_mf_nnndf_TAG20080602T013340_4476rf8l_.bkp
before you can use it. The validation delivered another file
/oraback1/flash_recovery_area/REMGT/backupset/2008_06_02/o1_mf_nnndf_TAG20080602T013340_4477p0db_.bkp
which is different.

So it's not SO strange ;)

And: You CAN't ignore that. What command causes this output?

Regards
Martin

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
www.usn-it.de

--
//www.freelists.org/webpage/oracle-l


Other related posts: