How to dump redo log entry(二)
ltered.
--获取转储文件的路径
col value for a60
SQL>
SQL> select * from v$diag_info;
INST_ID NAME VALUE
---------- -------------------------------------------------- ------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base /u01/app/oracle
1 ADR Home /u01/app/oracle/diag/rdbms/test/test
1 Diag Trace /u01/app/oracle/diag/rdbms/test/test/trace
1 Diag Alert /u01/app/oracle/diag/rdbms/test/test/alert
1 Diag Incident /u01/app/oracle/diag/rdbms/test/test/incident
1 Diag Cdump /u01/app/oracle/diag/rdbms/test/test/cdump
1 Health Monitor /u01/app/oracle/diag/rdbms/test/test/hm
1 Default Trace File /u01/app/oracle/diag/rdbms/test/test/trace/test_ora_4160.trc
1 Active Problem Count 1
1 Active Incident Count 4
转储指定 SCN 的 redo entry
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
455005
SQL>
update scott.test set LOC='BOSTON' where deptno=40;
1 row updated.
SQL> commit;
Commit complete.
SQL> select * from scott.test;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
455020
alter system dump logfile '+FRA/test/onlinelog/group_3.263.829746593' scn min 455005 scn max 455020;
SQL> select * from v$diag_info where NAME ='Default Trace File';
INST_ID NAME VALUE
---------- -------------------------------------------------- ------------------------------------------------------------
1 Default Trace File /u01/app/oracle/diag/rdbms/test/test/trace/test_ora_4160.trc
转储指定 RBA 的 redo entry
SQL> select group#,sequence#,BYTES/BLOCKSIZE as block# from v$log;
GROUP# SEQUENCE# BLOCK#
---------- ---------- ----------
1 1 20480
2 2 20480
3 3 20480
alter system dump logfile '+FRA/test/onlinelog/group_3.263.829746593' rba min 3 1 rba max 3 10;