- 最后登录
- 2016-11-20
- 在线时间
- 7 小时
- 威望
- 0
- 金钱
- 155
- 注册时间
- 2016-7-15
- 阅读权限
- 150
- 帖子
- 76
- 精华
- 0
- 积分
- 0
- UID
- 2455
|
10#
发表于 2016-7-19 15:49:23
10：
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
Answer: C
多个RMAN会话连接在数据库实例，当备份命令在服务会话中运行时，检查下列输出：
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
什么帮助你关联服务会话和通道
A.实现RMAN多路复用
B.在RMAN脚本中设置DEBUG ON
C.在RMAN脚本中指定命令ID
D.在RMAN BACKUP命令使用tag
答案:C
B,D选项和本题明显无关，可以排除。debug用于跟踪错误或一些问题，tag是标记整个备份集。
A.实现多路复用，并不能帮助你关联会话和RMAN通道，是RMAN备份的一种方式。
在RUN块中使用set command id 可以使得该信息出现在v$session.client_info中，这样就能帮助关联会话和通道。
例如：
RUN
{
ALLOCATE CHANNEL c1 TYPE disk;
SET COMMAND ID TO 'sess1';
BACKUP DATABASE;
}
在另一个会话
RUN
{
ALLOCATE CHANNEL c1 TYPE disk;
SET COMMAND ID TO 'sess2';
BACKUP DATABASE;
}
同时运行后，查询：
COLUMN CLIENT_INFO FORMAT a30
COLUMN SID FORMAT 999
COLUMN SPID FORMAT 9999
SELECT SID, SPID, CLIENT_INFO
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
AND CLIENT_INFO LIKE '%id=sess%';
包含rman channel的行是执行备份的通道会话，其他的行是连接目标数据库的会话
参考文档：http://docs.oracle.com/cd/E11882 ... roub.htm#sthref1769
参考：监控和优化RMAN：http://blog.csdn.net/rlhua/article/details/12510975
当有多个RMAN 会话正在运行时，最好使用SET COMMAND ID命令在备份期间将某个进程与某个通道相关联，如下所示：
1.在每个会话中，将命令ID 设置为不同的值，然后备份所需的对象。例如，在会话1 中输入下列内容：
RUN
{
SET COMMAND ID TO 'sess1';
BACKUP DATABASE;
}
在会话2 中运行的作业中将命令ID 设置为一个字符串，如sess2：
RUN
{
SET COMMAND ID TO 'sess2';
BACKUP DATABASE;
}
2.启动SQL*Plus 会话，然后在执行RMAN 作业时查询联接的V$SESSION和
V$PROCESS视图。例如，输入：
SELECT SID, SPID, CLIENT_INFO
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
AND CLIENT_INFO LIKE '%id=sess%';
如果在RMAN 作业中运行SET COMMAND ID命令，则CLIENT_INFO列会以下列格式显示：
id=command_id,rman channel=channel_id
例如，下面显示了一个示例输出：
SID SPID CLIENT_INFO
---- ------------ ------------------------------
11 8358 id=sess1
15 8638 id=sess2
14 8374 id=sess1,rman channel=c1
9 8642 id=sess2,rman channel=c1
sys@TEST0924> 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
---- ------------------------ ------------------------------
68 410 rman channel=ORA_DISK_1
160 722 rman channel=ORA_DISK_1
sys@TEST0924> SELECT s.sid, p.spid, s.client_info FROM v$process p, v$session s WHERE p.addr = s.paddr AND CLIENT_INFO like '%id=sess%';
SID SPID CLIENT_INFO
---- ------------------------ ------------------------------
7 653 id=sess1
Matching Server Sessions with Channels in Multiple RMAN Sessions
If more than one RMAN session is active, then it is possible for theV$SESSION.CLIENT_INFO column to yield the same information for a channel in each session. For example:
SID SPID CLIENT_INFO
---- ------------ ------------------------------
14 8374 rman channel=ORA_SBT_TAPE_1
9 8642 rman channel=ORA_SBT_TAPE_1
In this case, you have the following methods for determining which channel corresponds to whichSID value.
Obtaining the Channel ID from the RMAN Output
In this method, you must first obtain the sid values from the RMAN output and then use these values in your SQL query.
To correlate a process with a channel during a backup:
In an active session, run the RMAN job as usual and examine the output to get thesid for the channel. For example, the output may show:
Starting backup at 21-AUG-01
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=14 devtype=SBT_TAPE
Start a SQL*Plus session and then query the joined V$SESSION and V$PROCESS views while the RMAN job is executing. For example, enter:
COLUMN CLIENT_INFO FORMAT a30
COLUMN SID FORMAT 999
COLUMN SPID FORMAT 9999
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%'
/
Use the sid value obtained from the first step to determine which channel corresponds to which server session:
SID SPID CLIENT_INFO
---------- ------------ ------------------------------
14 2036 rman channel=ORA_SBT_TAPE_1
12 2066 rman channel=ORA_SBT_TAPE_1
Correlating Server Sessions with Channels by Using SET COMMAND ID
In this method, you specify a command ID string in the RMAN backup script. You can then queryV$SESSION.CLIENT_INFO for this string.
To correlate a process with a channel during a backup:
In each session, set the COMMAND ID to a different value after allocating the channels and then back up the desired object. For example, enter the following in session 1:
RUN
{
ALLOCATE CHANNEL c1 TYPE disk;
SET COMMAND ID TO 'sess1';
BACKUP DATABASE;
}
Set the command ID to a string such as sess2 in the job running in session 2:
RUN
{
ALLOCATE CHANNEL c1 TYPE sbt;
SET COMMAND ID TO 'sess2';
BACKUP DATABASE;
}
Start a SQL*Plus session and then query the joined V$SESSION and V$PROCESS views while the RMAN job is executing. For example, enter:
SELECT SID, SPID, CLIENT_INFO
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
AND CLIENT_INFO LIKE '%id=sess%';
If you run the SET COMMAND ID command in the RMAN job, then theCLIENT_INFO column displays in the following format:
id=command_id,rman channel=channel_id
For example, the following shows sample output:
SID SPID CLIENT_INFO
---- ------------ ------------------------------
11 8358 id=sess1
15 8638 id=sess2
14 8374 id=sess1,rman channel=c1
9 8642 id=sess2,rman channel=c1
The rows that contain the string rman channel show the channel performing the backup. The remaining rows are for the connections to the target database.
官方参考：http://docs.oracle.com/cd/E11882 ... roub.htm#sthref1769
|
|
|手机版|Archiver|Oracle数据库数据恢复、性能优化
IP卡
狗仔卡
显身卡