Oracle, LSSV, Backup to tape hangs indefinitely

From: Sune <sune_ahlgren_at_hotmail.com>
Date: 28 Sep 2004 04:59:54 -0700
Message-ID: <8a695a2a.0409280359.2b3eb006_at_posting.google.com>



Hi,

I've installed LSSV on the same server from which I'm trying to execute the following:

RMAN> BACKUP DEVICE TYPE sbt BACKUPSET ALL;

The respons is:

Starting backup at 2004-09-28
using target database controlfile instead of recovery catalog allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=174 devtype=SBT_TAPE channel ORA_SBT_TAPE_1: NMO v4.1.0.0
skipping backupset key 1; already backed up 1 time(s) input backupset count=2 stamp=538023833 creation_time=2004-09-28 channel ORA_SBT_TAPE_1: starting piece 1 at 2004-09-28

  • And here it hangs without anything happening

I execute the following in SQLPlus:

SQL> select sw.event, sw.state, s.SECONDS_IN_WAIT, s.CLIENT_INFO, p.spid from

  2     v$SESSION_WAIT sw, V$SESSION s, V$PROCESS p
  3     where sw.sid=s.sid and s.PADDR=p.ADDR AND sw.event like
'%sbt%';
  • And the output is:
EVENT                          STATE                SECONDS_IN_WAIT
CLIENT_INFO                    SPID
------------------------------ -------------------- ---------------
------------------------------ ------------
Backup: sbtbackup              WAITING                          773
rman channel=ORA_SBT_TAPE_1 27605
  • The output in 'sbtio.log' says: SBT-27605 09/28/04 01:42:52 PM do_info2: could not locate save set: c-3783320914-20040928-00
  • A pstack on process 27605 results in the following output:

pstack 27605
27605: oraclempctrig1
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))  ffffffff7c9a7d64 sigsuspend (ffffffff7fff6590)  ffffffff7c95b2e4 _libc_sleep (1e, ffffffff7c95b1e0, fffffff3, 11303c, ffffffff7b560cd0, ffffffff7b7379b8) + 104  ffffffff7b560cd0 nwora_open_backup (ffffffff7b754680, ffffffff7b7379b8, ffffffff7b7546f8, 2, 0, ffffffff7fff6958) + 534  ffffffff7b566e58 sbtbackup (0, 0, 4, 40000, ffffffff7b7379b8, 4) + 210
 0000000102f16a0c skgfqcre (ffffffff7fff6bf0, 104c55350, ffffffff7b964b48, 103e089f0, 7, 1) + 3ac  0000000100bcc204 ksfq_cre (ffffffff7fff6bf0, ffffffff7b964b18, 2000000, 104ba5968, 40000, 0) + 1a4
 0000000100bc287c ksfqfcrx (ffffffff7b970580, ffffffff7fff6bf0, 9, 104c561f8, 200, 1) + 69c
 00000001020235a4 krbydd (1ce4, 4, 380008, ffffffff7fff9360, 1c00, 5) + 1f84
 000000010201d90c krbycbp (ffffffff7fff9d9c, 9, ffffffff7fff934c, ffffffff7fff9350, ffffffff7fff9598, 0) + 4cc  0000000103633658 krbicbbp (0, ffffffff7fffa494, 1, 4c00, 0, 1) + 318  00000001032f9374 pevm_icd_call_common (ffffffff7ba79da8, ffffffff7fffc4a0, 14, 104c63758, 13, 3f0) + 254  00000001032c8f64 pfrinstr_ICAL (ffffffff7ba79da8, 12, ffffffff7ba79e10, 14, 3a0ad5c0c, 12) + 84  00000001032c40c8 pfrrun_no_tool (ffffffff7ba79da8, 3a0ad5c02, ffffffff7ba79e10, 1040ef488, 2001, 2001) + 48  00000001032c50d0 pfrrun (ffffffff7ba79e10, 200000, 0, 200000, ffffffff7ba79da8, 3a0ad6b5e) + 2f0
 0000000103311174 plsql_run (ffffffff7b95bb30, 264, 0, ffffdfff, ffffffff7fffc4a0, 0) + 274
 00000001032e334c pricar (63, ffffffff7fffbdf0, ffffffff7ba78a88, 104c63758, ffffffff7ba79da8, 0) + 4ac
 00000001032d699c pricbr (ffffffff7fffc4a0, ffffffff7fffbdf0, 103000, ffffffff7fffb0f0, fffc00, 1032d5d40) + 25c  00000001032db9b0 prient2 (ffffffff7fffbdf0, 1049ad, 104c68f28, ffffffff7fffd2b0, ffffffff7fffc4a0, ffffffff7ba79da8) + 250  00000001032db250 prient (1040e6418, 0, 20, ffffffff7ba78be8, 20, 0) + a10
 000000010324d008 kkxrpc (104ba0, 101648dea, ffffffff7fffeaf0, ffffffff7fffd348, 104ba8ff0, ffffffff7fffd2b8) + 348  0000000101a7b014 kporpc (1040e6000, 1040e6418, 104ba02a0, 104bab000, 104bab, f) + d4
 000000010029b278 opiodr (f, 104ba29b0, 103edcba0, 104ba2, 104800, 103c00) + 598
 0000000102ca9fb4 ttcpip (104ba8ff0, 8, ffffffff7fffeaf0, ffffffff7fffdde8, 103db84d8, ffffffff7fffdde4) + 694  0000000100298608 opitsk (10029a000, 1, 0, ffffffff7fffec48, 104ba8ff0, 104ba8ff8) + 428
 0000000101a7a784 opiino (104ba7000, 104b9ff60, 0, 0, f5, 104ba7e30) + 404
 000000010029b278 opiodr (4, 104ba29b0, 103edc920, 10000, 104ba8, 104800) + 598
 0000000100297394 opidrv (0, 4, 104ba2, 104ba8ff0, 0, 3c) + 354  0000000100294a48 sou2o (ffffffff7ffff918, 3c, 4, ffffffff7ffff8f8, 104619000, 104619) + 48
 0000000100272d54 main (2, ffffffff7ffff9f8, ffffffff7ffffa10, 0, 0, 100000000) + 94
 0000000100272c9c _start (0, 0, 0, 0, 0, 0) + 17c

Can anyone please help me with this?

BRs
/Olle Received on Tue Sep 28 2004 - 13:59:54 CEST

Original text of this message