Analysis of OCP questions 053-61 RMAN set command id to, ocprman

Source: Internet
Author: User

Analysis of OCP questions 053-61 RMAN set command id to, ocprman

61. You frequently have multiple RMAN sessions running, and you want to be able to easily identify each
Job via the CLIENTJNFO column of the dynamic performance view V $ SESSION. What RMAN command
Can you run to set the value for this column?


A. set clientinfo to 'rjb rman session ';
B. set command id to 'rjb rman session ';
C. set channelid to 'rjb rman session ';
D. set session_name to 'rjb rman session

Original answer: C

Correct answer: B

 

Verification:

RMAN> set command id to 'rjb rman session ';

Executing COMMAND: SET COMMAND ID

SELECT t. SID, t. USERNAME, t. STATUS, t. MACHINE, t. CLIENT_INFO FROM v $ session t order by client_info;

Certificate -------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sid username status machine CLIENT_INFO
1 70 sys inactive workgroup \ IDYLAN id = RJB rman session

 

[Official documentation]

COMMAND ID TO'string'

 

Enters the specified string intoV$SESSION.CLIENT_INFOColumn of all channels. Use this information to determine which Oracle server sessions correspond to which RMAN channels.SET COMMAND IDCommand applies only to channels that are already allocated.

TheV$SESSION.CLIENT_INFOColumn contains information for each RMAN server session. The data appears in one of the following formats:

  • id=string
  • id=string,ch=channel_id
The first form appears in the RMAN target database connection. The second form appears in all allocated channels. When the current job is complete,V$SESSION.CLIENT_INFOColumn will be cleared.

 

 




Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.