rman 简易 debug

为了分析rman备份慢可以开启debug模式

export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"

rman target / debug trace=/tmp/rmanDebug.trc log=/tmp/rmanLog.txt
sql "alter session set tracefile_identifier=''rman_10046''";
sql "alter session set events ''10046 trace name context forever,level 12''";
backup datafile 3;

或者
run
{
allocate channel c1 device type disk debug "medium";
backup datafile 7;
}
debug级别可选highest或high或medium

然后查看/tmp目录下的两个文件，和告警日志目录下的带有rman_10046的trc文件。

参考：Doc ID 1198753.1


rman专业级诊断

开启跟踪
Oracle11g and earlier:

-- ksrpc tracing
alter system set events '10294 trace name context forever, level 1';
-- ksfd tracing
alter system set events '10298 trace name context forever, level 3';
-- krb_trace
alter system set events 'logon trace name krb_trace level 15';

Oracle12c and higher:

alter system set events 'trace[KRB.*] disk high, memory high';


重新备份
export NLS_DATE_FORMAT='YYYY-mm-dd HH24MISS'
rman debug all trace=srdc_rman_active_dup_debug_5.trc log=srdc_rman_active_dup_output_5.log
RMAN>执行脚本

禁用跟踪
11g and earlier:

-- ksrpc tracing
alter system set events '10294 trace name context off';
-- ksfd tracing
alter system set events '10298 trace name context off';
-- krb_trace
alter system set events 'logon trace name krb_trace off';

12c and higher:

alter system set events 'trace[KRB.*] off';


参考：1941758.1