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
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.
本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/7623586.html，如需转载请自行联系原作者
