RMAN的监控和调整

1. 并行备份集
2. 监控RMAN会话
3. 监控RMAN完成进度
4. 解释RMAN消息输出

--并行备份集
为提高性能，分配多个通道并将文件分配给特定通道。
需要要I/O资源充足的时候。

可以通过设置更改并行度。
RMAN> show all;

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default



手动分配通道
RMAN> run {
2> allocate channel a1 type disk;
3> allocate channel a2 type disk;
4> backup datafile 2,3;
5> release channel a1;
6> release channel a2;
7> }

allocated channel: a1
channel a1: SID=48 device type=DISK

allocated channel: a2
channel a2: SID=30 device type=DISK

Starting backup at 20-DEC-16
channel a1: starting full datafile backup set
channel a1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/PROD2/sysaux01.dbf
channel a1: starting piece 1 at 20-DEC-16
channel a2: starting full datafile backup set
channel a2: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/PROD2/undotbs01.dbf
channel a2: starting piece 1 at 20-DEC-16
channel a2: finished piece 1 at 20-DEC-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD2/backupset/2016_12_20/o1_mf_nnndf_TAG20161220T202210_d5l8mmcm_.bkp tag=TAG20161220T202210 comment=NONE
channel a2: backup set complete, elapsed time: 00:00:08
channel a1: finished piece 1 at 20-DEC-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD2/backupset/2016_12_20/o1_mf_nnndf_TAG20161220T202210_d5l8mmcs_.bkp tag=TAG20161220T202210 comment=NONE
channel a1: backup set complete, elapsed time: 00:00:57
Finished backup at 20-DEC-16

Starting Control File Autobackup at 20-DEC-16
piece handle=/u01/app/oracle/fast_recovery_area/PROD2/autobackup/2016_12_20/o1_mf_n_931119788_d5l8ofqf_.bkp comment=NONE
Finished Control File Autobackup at 20-DEC-16

released channel: a1

released channel: a2
           

--监控RMAN会话
通过查询V$SESSION和V$PROCESS可确定服务器会话和RMAN通道之间的关系。
如果正在监视多个会话，请使用SET COOMMAND。

RMAN> backup full database plus archivelog;  --先执行备份


Starting backup at 20-DEC-16
current log archived
allocated channel: ORA_DISK_1

同时再去查找视图

[email protected]> 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
---------- ------------------------ ----------------------------------------------------------------
	48 3633 		    rman channel=ORA_DISK_1
	
           

--监控RMAN完成进度

[email protected]>SELECT OPNAME, CONTEXT, SOFAR, TOTALWORK,
ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%'
AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK != 0
AND SOFAR <> TOTALWORK;

OPNAME				  CONTEXT      SOFAR  TOTALWORK %_COMPLETE
------------------------------ ---------- ---------- ---------- ----------
RMAN: full datafile backup		1      50138	 229760      21.82

[email protected]> /

OPNAME				  CONTEXT      SOFAR  TOTALWORK %_COMPLETE
------------------------------ ---------- ---------- ---------- ----------
RMAN: full datafile backup		1      62362	 229760      27.14

[email protected]> /

OPNAME				  CONTEXT      SOFAR  TOTALWORK %_COMPLETE
------------------------------ ---------- ---------- ---------- ----------
RMAN: full datafile backup		1      73370	 229760      31.93

[email protected]> /

OPNAME				  CONTEXT      SOFAR  TOTALWORK %_COMPLETE
------------------------------ ---------- ---------- ---------- ----------
RMAN: full datafile backup		1      79642	 229760      34.66
           

--解释RMAN消息输出
可在以下内容中找到RMAN故障诊断信息：
	RMAN命令输出。  --一般错误根据命令输出就可以定位原因。
	RMAN跟踪文件。
	预警日志。
	Oracle Server跟踪文件。
	sbtio.log文件。