RE: rman strangeness

  • From: "Stephens, Chris" <chris_stephens@xxxxxxxxxxxx>
  • To: "Martin Klier" <usn@xxxxxxxxx>
  • Date: Mon, 2 Jun 2008 10:19:19 -0500

" What command causes this output?"

Backup recovery area;

...a subsequent attempt to backup the recovery area succeeds far more
often than not.



-----Original Message-----
From: Martin Klier [mailto:usn@xxxxxxxxx] 
Sent: Monday, June 02, 2008 10:17 AM
To: Stephens, Chris
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: rman strangeness

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_TAG
20080602T013340_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_TA
G20080602T013340_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_TAG
20080602T013340_4477p0db_.bkp
> 
> channel ORA_DISK_1: restored backup piece 1
> 
> piece
>
handle=/oraback1/flash_recovery_area/REMGT/backupset/2008_06_02/o1_mf_nn
ndf_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_TAG
20080602T013340_4476rf8l_.bkp
before you can use it. The validation delivered another file
/oraback1/flash_recovery_area/REMGT/backupset/2008_06_02/o1_mf_nnndf_TAG
20080602T013340_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


CONFIDENTIALITY NOTICE: 
        This message is intended for the use of the individual or entity to 
which it is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law.  If the reader of 
this message is not the intended recipient or the employee or agent responsible 
for delivering this message to the intended recipient, you are hereby notified 
that any dissemination, distribution or copying of this communication is 
strictly prohibited.  If you have received this
communication in error, please notify us immediately by email reply.



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


Other related posts: