FW: rman strangeness
Date: Mon, 2 Jun 2008 09:52:56 -0500
Sorry, the backup piece does not show up in the recovery catalog at all. Disregard the validate backupset output.
According to rman, the backup to tape failed. According to Veritas it succeeded.
From: Stephens, Chris
Sent: Monday, June 02, 2008 9:36 AM
Subject: rman strangeness
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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-12009: command aborted because some backup pieces could not be located
RMAN-12008: could not locate backup piece
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
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
channel ORA_DISK_1: restored backup piece 1
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?
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.