28 May, 2017

How to check RMAN backup channels

set lines 200
set pages 200


select s.sid,p.spid,s.client_info
from v$process p, v$session s
where p.addr = s.paddr and client_info like '%rman%';



       SID SPID                     CLIENT_INFO
---------- ------------------------ ---------------------------
      1187 20672                    rman channel=ORA_DISK_5
      1224 20673                    rman channel=ORA_DISK_6
      1628 20674                    rman channel=ORA_DISK_7
       268 20667                    rman channel=ORA_DISK_1
       656 20668                    rman channel=ORA_DISK_2
       844 20669                    rman channel=ORA_DISK_3
       962 20671                    rman channel=ORA_DISK_4
      1665 20685                    rman channel=ORA_DISK_8
      2087 20731                    rman channel=ORA_DISK_13
      2386 20692                    rman channel=ORA_DISK_9
      2536 20705                    rman channel=ORA_DISK_10
      2723 20710                    rman channel=ORA_DISK_11
       875 20719                    rman channel=ORA_DISK_12
      2220 20732                    rman channel=ORA_DISK_14
      2625 20733                    rman channel=ORA_DISK_15
      2667 20738                    rman channel=ORA_DISK_16

16 rows selected.


No comments:

Post a Comment

OEM Agent Installation

./agentDeploy.sh AGENT_BASE_DIR=/u001/oracle/product/agent13c OMS_HOST=oem-dev.xxx.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=*****...