通过oradebug dump redo header信息
1.oradebug setmypid
2.oradebug tracefile_name
3.oradebug dump redohdr 4
或者
alter session set events ‘immediate trace name redohdr level 4’;
通过oradebug dump redo record信息
1.oradebug setmy pid
2.oradebug tracefile_name
3.oradebug dump redologs 10
或者
alter session set events ‘immediate trace name redologs level 10’;
dump单独的logfile信息
alter system dump logfile ‘+DATA/WXDB/ONLINELOG/group_1.261.1031895681’;