Re: RMAN "stuck" on SQLNet

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: _at_OracleSK

> Chris Taylor <christopherdtaylor1994_at_gmail.com> 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_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