RMAN "stuck" on SQLNet

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 4 Jan 2018 10:51:02 -0600
Message-ID: <CAP79kiS413wD9knx6V0VCW+EXTcEsM0UM5uQ6-L74NrM1iMqvA_at_mail.gmail.com>



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_at_hostname.redacted SQL*Net message from client 45934.531794 Idle
148 6769 SYS rman_at_hostname.redacted SQL*Net message from client 44724.14675 Idle
338 3826 SYS rman_at_hostname.redacted SQL*Net message from client 170.757525 Idle
359 59947 SYS rman_at_hostname.redacted SQL*Net message from client 170.767085 Idle
380 37145 SYS rman_at_hostname.redacted SQL*Net message from client 0.006576 Idle
401 10755 SYS rman_at_hostname.redacted SQL*Net message from client 767.152796 Idle
2185 26837 SYS rman_at_hostname.redacted SQL*Net message from client 0.791679 Idle
2227 53503 SYS rman_at_hostname.redacted SQL*Net message from client 44724.146262 Idle
2269 28738 SYS rman_at_hostname.redacted SQL*Net break/reset to client 45461.506918 Application
2290 55952 SYS rman_at_hostname.redacted SQL*Net message from client 45384.358042 Idle
2311 12729 SYS rman_at_hostname.redacted SQL*Net message from client 45204.297414 Idle
2332 28712 SYS rman_at_hostname.redacted SQL*Net message from client 45044.216679 Idle
2353 384 SYS rman_at_hostname.redacted SQL*Net message from client 45934.541706 Idle
2374 45826 SYS rman_at_hostname.redacted SQL*Net message from client 46308.688279 Idle
2395 47415 SYS rman_at_hostname.redacted SQL*Net message from client 45124.256283 Idle
2416 58529 SYS rman_at_hostname.redacted SQL*Net message from client 44994.200668 Idle
2437 37004 SYS rman_at_hostname.redacted SQL*Net message from client 45204.287282 Idle
2458 31528 SYS rman_at_hostname.redacted SQL*Net message from client 44974.182189 Idle
2479 28402 SYS rman_at_hostname.redacted SQL*Net message from client 45584.422033 Idle
2500 12880 SYS rman_at_hostname.redacted SQL*Net message from client 45074.231328 Idle
2542 14309 SYS rman_at_hostname.redacted SQL*Net message from client 45174.272327 Idle
2563 31481 SYS rman_at_hostname.redacted SQL*Net message from client 45574.408916 Idle

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 04 2018 - 17:51:02 CET

Original text of this message