[20160902][轉載]跟蹤rman操作.txt

[20160902]跟蹤rman操作.txt

--轉載：跟蹤rman

--以前僅僅知道debug，沒有知道這麼細，做一個記錄，原連結裡面還有DGMGRL，EXPDP / IMPDP，SRVCTL，OPATCH，10046事件的跟蹤。

RMAN

RMAN is the Oracle utility used to backup and recover your databases. To enable tracing is RMAN, you have to switch rman is "debug" mode.

This mode can be enabled directly in rman:

[oracle@oel7 ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Feb 24 15:45:13 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1413029491)
 
RMAN> debug on
 
RMAN-03036: Debugging set to level=9[MEDIUM], types=ALL
DBGSQL: TARGET> begin dbms_rcvman.setDebugOn; dbms_rcvman.dumpPkgState('Debug On'); end;
DBGSQL: sqlcode = 0
DBGRCVMAN: ENTERING dumpPkgState Debug On
.../...

Or (much better) it can be enabled with the debug option in the rman command, and by specifying a trace file :
   
[oracle@oel7 ~]$ rman target / debug trace=tracefile.trc
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Feb 24 15:22:10 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: ORCL (DBID=1413029491)
RMAN> disconnect

All the debug stuff is then located in your "tracefile.trc" file.

You can enable tracing on specific component in rman :

    SQL: for tracing SQL queries generated by rman
    RESTORE: for tracing restore operation only
    RECOVER: for tracing recovery operation only
    RESYNC: for tracing synchronization operation only
    DUPLICATE: for tracing duplicate operation only

And for each or all of these component, you can set a verbosity level from 1 (lowest) to 10 (highest). 9 is the default
verbosity level. Sometimes, you can change the verbosity level without any change in your tracefile.

Here are some examples (point that many components can be traced at the same time):
   
[oracle@oel7 ~]$ rman target / debug recover level=10 trace=tracefile.trc
[oracle@oel7 ~]$ rman target / debug sql level=1 trace=tracefile.trc
RMAN> debug restore,sql level=10