[Oracle]发生 ora-06502 RMAN 在对 catalog DB 同期时出错的调查方法
Catalog DB resync error:
1, setting on the server that starts the RMAN client
$ Export EVENT_10928 = 1
$ Rman target <username> / <password> @ <connection descriptor> catalog <username> / <password> debug trace = / tmp / rmanDebug.trc log = / tmp / rmanLog.txt
RMAN> sql "alter session set tracefile_identifier = '' rman - 10046 ''" ";
RMAN> sql "alter session set events '' 10046 trace name context forever, level 12 ''" "
RMAN> sql "alter session set events '' 6502 trace name errorstack level 3 ''";
RMAN> debug all level = 15
2, With the RMAN connection of the target DB held, the setting of the catalog DB
SQL> alter system set events '10046 trace name context forever, level 12';
SQL> alter system set events '6502 trace name errorstack level 3';
3, Reproduce the error on the target DB side.
RMAN> resync catalog;
RMAN> exit;
4, Cancel EVENT_10928 on the server that starts the RMAN client
$ Unset EVENT_10928
5, Cancel event setting on the catalog DB side.
SQL> alter system set events '10046 trace name context off';
SQL> alter system set events '6502 trace name errorstack off';
The file generated is as follows:
■ Target DB side:
<SID> _ora _ <SPID> _rman _ 10046.trc output to user_dump_dest
■ Catalog DB side:
<SID> _ora _ <SPID> .trc output to user_dump_dest
■ Server that started RMAN client:
/tmp/rmanDebug.trc
/tmp/rmanLog.txt
Note: The information in EVENT_10928 is output to rmanLog.txt.
最新文章
- 3. SVM分类器求解(1)——Lagrange duality
- Redis配置文件参数说明
- 离线渲染中的不规则光源(Meshlight)
- Activity切换后,如i何保存上一个Activit的状态
- 分形树Fractal tree介绍——具体如何结合TokuDB还没有太懂,先记住其和LSM都是一样的适合写密集
- Debian字符模式下修改显示分辨率
- vimdiff: 使用Vim中强大的文件diff功能[转]
- 用命令行方式关闭linux防火墙
- IntelliJ IDEA常见问题解决办法汇总
- scauoj 18025 小明的密码 数位DP
- Buffer深入分析
- angularui 自定义选项卡
- “华尔街之狼”:ICO是“史上最大骗局”
- Android之MaterialDesign应用技术2-仿支付宝上滑搜索框缓慢消失
- springmvc 项目完整示例07 设置配置整合springmvc springmvc所需jar包springmvc web.xml文件配置
- 消除导入MNIST数据集发出的警告信息
- 诡异的楼梯 HDU - 1180
- centos6默认python2.6升级2.7 卸载python2.6升级2.7
- mingw 构建 mysql-connector-c-6.1.9记录
- bzr: ERROR: These branches have diverged. Use the missing command to see how.