暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

rman 10046

原创 许玉冲 2023-07-25
195

export NLS_DATE_FORMAT='DD-MON-YYYY HH24MISS'
rman debug all trace=debug.trc log=debug.log
connect target /;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
set echo on;
run {
sql "alter session set max_dump_file_size=''UNLIMITED''";
sql "alter session set tracefile_identifier=''RMAN''" ;
sql "alter session set events ''10046 trace name context forever, level 12''";
sql "alter session set events ''trace[KRB.*] disk=highest,memory=highest''";
debug on;
catalog start with '/test/archivelog';
debug off;
sql "alter session set events ''10046 trace name context off''";
sql "alter session set events ''TRACE[krb.*] off''";
}



Start a sqlplus session and identify the RMAN channels and spid during the
backup
SELECT sid, spid, client_info
FROM v$process p, v$session s
WHERE p.addr = s.paddr
AND client_info LIKE '%id=rman%';

run select for processes to os spid
$ sqlplus
connect / as sysdba
oradebug setospid <process ID>
oradebug unlimit
oradebug dump errorstack 3

最后修改时间:2023-07-25 11:24:57
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论