What could have helped you to correlate server sessions with channels?

Multiple RMAN sessions are connected to the database instance.

Examine the following output when backup commands are running in server sessions:

SQL> 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
— —– —————————-
103 25280 rman channel 1=ORA_DISK_1
151 25292 rman channel 1=ORA_DISK_2

What could have helped you to correlate server sessions with channels?

Multiple RMAN sessions are connected to the database instance.

Examine the following output when backup commands are running in server sessions:

SQL> 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
— —– —————————-
103 25280 rman channel 1=ORA_DISK_1
151 25292 rman channel 1=ORA_DISK_2

What could have helped you to correlate server sessions with channels?

A.
Implement RMAN multiplexing

B.
Set the DEBUG ON in the RMAN script

C.
Specify the command ID in the RMAN script

D.
Use a tag with the RMAN BACKUP command



Leave a Reply 0

Your email address will not be published. Required fields are marked *