Hey Chris,
there is nothing to strace as "SQL*Net break/reset to client" is shown when an
error happens or an unhandled exception is raised. As RMAN is just PL/SQL code
I would check for such issues.
Just trace RMAN (debug command line option) and have a look what is happening
:-)
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
Chris Taylor <christopherdtaylor1994@xxxxxxxxx> hat am 4. Januar 2018 um--
17:51 geschrieben:
12.1.0.2
RHEL 7 64-bit
backup location = NAS storage
Backup Type = Level 0
Backup is of Production Standby DB
Backup does NOT use catalog
I need to know how to dig into this - specifically sid 2269. Can I strace
this or something on linux - how would YOU go about investigating this?
V$SESSION shows:
SID SERIAL# USERNAME PROGRAM EVENT WAIT_TIME_SECS WAIT_CLASS
65 45315 SYS rman@hostname.redacted SQL*Net message from client 45934.531794
Idle
148 6769 SYS rman@hostname.redacted SQL*Net message from client 44724.14675
Idle
338 3826 SYS rman@hostname.redacted SQL*Net message from client 170.757525
Idle
359 59947 SYS rman@hostname.redacted SQL*Net message from client 170.767085
Idle
380 37145 SYS rman@hostname.redacted SQL*Net message from client 0.006576 Idle
401 10755 SYS rman@hostname.redacted SQL*Net message from client 767.152796
Idle
2185 26837 SYS rman@hostname.redacted SQL*Net message from client 0.791679
Idle
2227 53503 SYS rman@hostname.redacted SQL*Net message from client
44724.146262 Idle
2269 28738 SYS rman@hostname.redacted SQL*Net break/reset to client
45461.506918 Application
2290 55952 SYS rman@hostname.redacted SQL*Net message from client
45384.358042 Idle
2311 12729 SYS rman@hostname.redacted SQL*Net message from client
45204.297414 Idle
2332 28712 SYS rman@hostname.redacted SQL*Net message from client
45044.216679 Idle
2353 384 SYS rman@hostname.redacted SQL*Net message from client 45934.541706
Idle
2374 45826 SYS rman@hostname.redacted SQL*Net message from client
46308.688279 Idle
2395 47415 SYS rman@hostname.redacted SQL*Net message from client
45124.256283 Idle
2416 58529 SYS rman@hostname.redacted SQL*Net message from client
44994.200668 Idle
2437 37004 SYS rman@hostname.redacted SQL*Net message from client
45204.287282 Idle
2458 31528 SYS rman@hostname.redacted SQL*Net message from client
44974.182189 Idle
2479 28402 SYS rman@hostname.redacted SQL*Net message from client
45584.422033 Idle
2500 12880 SYS rman@hostname.redacted SQL*Net message from client
45074.231328 Idle
2542 14309 SYS rman@hostname.redacted SQL*Net message from client
45174.272327 Idle
2563 31481 SYS rman@hostname.redacted SQL*Net message from client
45574.408916 Idle
