个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2021-11-07 16:40:42
为了分析rman备份慢可以开启debug模式
然后查看/tmp目录下的两个文件，和告警日志目录下的带有rman_10046的trc文件。
参考：doc id 1198753.1
rman专业级诊断
-
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
参考：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
给主人留下些什么吧！~~