RMAN DEBUG & TRACING

Turn debug on

$ rman target / catalog user/pwd@db debug trace rman.trc log rman.log
RMAN>


Additional Tracing at the channel level

RMAN> run {
2> allocate channel ch01 type sbt trace=5;
3> send 'NB_ORA_CLIENT=hypprdbv1-bn';
4> RESTORE SPFILE to pfile '/export/home/oracle/sshaik/initHYPP.ora' from autobackup maxdays 20;
5> }

allocated channel: ch01
channel ch01: sid=34 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

sent command to channel: ch01

Starting restore at 07-JUL-10

channel ch01: looking for autobackup on day: 20100707

Trace a SID

SQL> EXEC DBMS_MONITOR.session_trace_enable(session_id=>918,serial_num=>32481);
SQL> EXEC DBMS_MONITOR.session_trace_enable(session_id =>918,serial_num=>32481, waits=>TRUE, binds=>FALSE);
SQL> EXEC DBMS_MONITOR.session_trace_disable(session_id=>918,serial_num=>32481);