转储oracle的redo文件

1、确定当前使用的redo文件

SQL> select member from v$logfile where group# = ( select group# from v$log where status = 'CURRENT');

MEMBER
--------------------------------------------------------------------------------
/home/oracle/oradata/orcl/redo02.log

2、进行转储

SQL> alter system dump logfile '/home/oracle/oradata/orcl/redo02.log' scn min  2135800 scn max 2135818;

System altered.

SQL> oradebug setmypid
Statement processed.
SQL> oradebug tracefile_name
/home/oracle/admin/orcl/udump/orcl_ora_5597.trc

3、转储的语法

 ALTER SYSTEM DUMP LOGFILE 'FileName'
        SCN MIN MinimumSCN
        SCN MAX MaximumSCN
        TIME MIN MinimumTime
        TIME MAX MaximumTime
        LAYER Layer
        OPCODE Opcode
        DBA MIN FileNumber . BlockNumber
        DBA MAX FileNumber . BlockNumber
        RBA MIN LogFileSequenceNumber . BlockNumber
        RBA MAX LogFileSequenceNumber . BlockNumber;

4、查看内容

[oracle@kel orcl]$ cat  /home/oracle/admin/orcl/udump/orcl_ora_5597.trc

for linux and python