Oracle, LSSV, Backup to tape hangs indefinitely
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 773rman 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