RMAN的监控和调整

来源：互联网发布：淘宝关闭货到付款流程编辑：程序博客网时间：2024/06/03 15:22

并行备份集
监控RMAN会话
监控RMAN完成进度
解释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: a1channel a1: SID=48 device type=DISKallocated channel: a2channel a2: SID=30 device type=DISKStarting backup at 20-DEC-16channel a1: starting full datafile backup setchannel a1: specifying datafile(s) in backup setinput datafile file number=00002 name=/u01/app/oracle/oradata/PROD2/sysaux01.dbfchannel a1: starting piece 1 at 20-DEC-16channel a2: starting full datafile backup setchannel a2: specifying datafile(s) in backup setinput datafile file number=00003 name=/u01/app/oracle/oradata/PROD2/undotbs01.dbfchannel a2: starting piece 1 at 20-DEC-16channel a2: finished piece 1 at 20-DEC-16piece handle=/u01/app/oracle/fast_recovery_area/PROD2/backupset/2016_12_20/o1_mf_nnndf_TAG20161220T202210_d5l8mmcm_.bkp tag=TAG20161220T202210 comment=NONEchannel a2: backup set complete, elapsed time: 00:00:08channel a1: finished piece 1 at 20-DEC-16piece handle=/u01/app/oracle/fast_recovery_area/PROD2/backupset/2016_12_20/o1_mf_nnndf_TAG20161220T202210_d5l8mmcs_.bkp tag=TAG20161220T202210 comment=NONEchannel a1: backup set complete, elapsed time: 00:00:57Finished backup at 20-DEC-16Starting Control File Autobackup at 20-DEC-16piece handle=/u01/app/oracle/fast_recovery_area/PROD2/autobackup/2016_12_20/o1_mf_n_931119788_d5l8ofqf_.bkp comment=NONEFinished Control File Autobackup at 20-DEC-16released channel: a1released channel: a2

--监控RMAN会话通过查询V$SESSION和V$PROCESS可确定服务器会话和RMAN通道之间的关系。如果正在监视多个会话，请使用SET COOMMAND。RMAN> backup full database plus archivelog;  --先执行备份Starting backup at 20-DEC-16current log archivedallocated channel: ORA_DISK_1同时再去查找视图SYS@PROD2> select s.sid, p.spid, s.client_infofrom v$process p, v$session swhere p.addr=s.paddr and client_info like 'rman%';       SID SPID     CLIENT_INFO---------- ------------------------ ----------------------------------------------------------------48 3633     rman channel=ORA_DISK_1

--监控RMAN完成进度SYS@PROD2>SELECT OPNAME, CONTEXT, SOFAR, TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"FROM V$SESSION_LONGOPSWHERE OPNAME LIKE 'RMAN%'AND OPNAME NOT LIKE '%aggregate%'AND TOTALWORK != 0AND SOFAR <> TOTALWORK;OPNAME  CONTEXT      SOFAR  TOTALWORK %_COMPLETE------------------------------ ---------- ---------- ---------- ----------RMAN: full datafile backup1      50138 229760      21.82SYS@PROD2> /OPNAME  CONTEXT      SOFAR  TOTALWORK %_COMPLETE------------------------------ ---------- ---------- ---------- ----------RMAN: full datafile backup1      62362 229760      27.14SYS@PROD2> /OPNAME  CONTEXT      SOFAR  TOTALWORK %_COMPLETE------------------------------ ---------- ---------- ---------- ----------RMAN: full datafile backup1      73370 229760      31.93SYS@PROD2> /OPNAME  CONTEXT      SOFAR  TOTALWORK %_COMPLETE------------------------------ ---------- ---------- ---------- ----------RMAN: full datafile backup1      79642 229760      34.66

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

0 0