rman strangeness
Date: Mon, 2 Jun 2008 09:35:52 -0500
Message-ID: <7070047601C21A4CB387D50AD3661F6E09DF0815@050EXCHANGE.research.na.admworld.com>
I've been battling rman strangeness for some time. Every couple of
days, messages like the following will show up in our rman logs:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
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)
Recovery Manager complete.
We use veritas' netback to write to tape. Veritas reports everything as completing successfully.
When I validate the backupset this piece is a part of, it validates properly:
Backup Set Copy #2 of backup set 87489
Device Type Elapsed Time Completion Time Compressed Tag
- ------------ --------------- ---------- ---
SBT_TAPE 00:00:01 02-JUN-08 NO TAG20080602T013340 List of Backup Pieces for backup set 87489 Copy #2
BP Key Pc# Status Media Piece Name ------- --- ----------- ----------------------- ---------- 87714 1 AVAILABLE 9ljhsojg_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> Anyone know what is happening here? Anyone know if I can consistently and safely ignore this error stack?
Thanks!
Chris
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 02 2008 - 09:35:52 CDT