转载

[20160223]检查redo日志的完整性.txt

--在论坛里问的问题：
http://www.itpub.net/thread-2053302-1-1.html

1.直接检查dump logfile 后面加入参数validate。

SYS@book> @ &r/logfile
GROUP# THREAD# SEQUENCE#       BYTES BLOCKSIZE MEMBERS ARC STATUS     FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE# NEXT_TIME           GROUP# STATUS     TYPE       MEMBER                        IS_
------ ------- --------- ----------- --------- ------- --- ---------- ------------- ------------------- ------------ ------------------- ------ ---------- ---------- ----------------------------- ---
     1       1       382    52428800       512       1 YES INACTIVE      1.3223E+10 2016-02-22 11:09:33   1.3223E+10 2016-02-22 22:00:13      1            ONLINE     /mnt/ramdisk/book/redo01.log NO
     2       1       383    52428800       512       1 YES INACTIVE      1.3223E+10 2016-02-22 22:00:13   1.3223E+10 2016-02-22 22:36:19      2            ONLINE     /mnt/ramdisk/book/redo02.log NO
     3       1       384    52428800       512       1 NO CURRENT       1.3223E+10 2016-02-22 22:36:19   2.8147E+14                          3            ONLINE     /mnt/ramdisk/book/redo03.log NO

SYS@book> alter system dump logfile '/mnt/ramdisk/book/redo03.log' validate;
System altered.

2.使用DBMS_HM包：

BEGIN
   DBMS_HM.RUN_CHECK
   (
      check_name   => 'Redo Integrity Check'
     ,run_name     => 'redo_check'
     ,input_params => 'SCN_TEXT=0'
   );
END;
/

--可以加入scn_text 表示从某个scn开始。

SYS@book> select dbms_hm.get_run_report('redo_check') from dual;
DBMS_HM.GET_RUN_REPORT('REDO_CHECK')
-----------------------------------------------------------------
Basic Run Information
Run Name                     : redo_check
Run Id                       : 4221
Check Name                   : Redo Integrity Check
Mode                         : MANUAL
Status                       : COMPLETED
Start Time                   : 2016-02-23 11:31:10.753766 +08:00
End Time                     : 2016-02-23 11:31:12.387839 +08:00
Error Encountered            : 0
Source Incident Id           : 0
Number of Incidents Created : 0
Input Paramters for the Run
SCN_TEXT=0
Run Findings And Recommendations

--如何删除，仅仅知道使用adrci：
adrci> show hm_run -p "RUN_ID=4261"
ADR Home = /u01/app/oracle/diag/rdbms/book/book:
*************************************************************************
**********************************************************
HM RUN RECORD 1
**********************************************************
   RUN_ID                        4261
   RUN_NAME                      redo_check1
   CHECK_NAME                    Redo Integrity Check
   NAME_ID                       4
   MODE                          0
   START_TIME                    2016-02-23 11:34:27.605690 +08:00
   RESUME_TIME                   <NULL>
   END_TIME                      2016-02-23 11:34:29.116844 +08:00
   MODIFIED_TIME                 2016-02-23 11:34:35.227078 +08:00
   TIMEOUT                       0
   FLAGS                         0
   STATUS                        5
   SRC_INCIDENT_ID               0
   NUM_INCIDENTS                 0
   ERR_NUMBER                    0
   REPORT_FILE                   /u01/app/oracle/diag/rdbms/book/book/hm/HMREPORT_redo_check1.hm
1 rows fetched

adrci> select * from HM_RUN where run_id=4261;

ADR Home = /u01/app/oracle/diag/rdbms/book/book:
*************************************************************************
RUN_ID RUN_NAME CHECK_NAME NAME_ID MODE START_TIME RESUME_TIME END_TIME MODIFIED_TIME TIMEOUT FLAGS STATUS SRC_INCIDENT_ID NUM_INCIDENTS ERR_NUMBER REPORT_FILE
------ ------------ -------------------- -------- ----- --------------------------------- ----------- --------------------------------- --------------------------------- ------- ----- ------ --------------- ------------- ---------- ----------------------------------------------------------------
4261 redo_check1 Redo Integrity Check 4 0 2016-02-23 11:34:27.605690 +08:00 2016-02-23 11:34:29.116844 +08:00 2016-02-23 11:34:35.227078 +08:00 0 0 5 0 0 0 /u01/app/oracle/diag/rdbms/book/book/hm/HMREPORT_redo_check1.hm
1 rows fetched

adrci> delete from HM_RUN where run_id=4261;
1 Row Deleted

adrci> commit ;
Transaction Committed

adrci> select * from HM_RUN where run_id=4261;
ADR Home = /u01/app/oracle/diag/rdbms/book/book:
*************************************************************************
0 rows fetched

3. 使用rman的validate:

RMAN> validate archivelog sequence 4830;

Starting validate at 2016-02-23 14:50:18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting validation of archived log
channel ORA_DISK_1: specifying archived log(s) for validation
input archived log thread=1 sequence=4830 RECID=1626 STAMP=904574667
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Archived Logs
=====================
Thrd Seq Status Blocks Failing Blocks Examined Name
---- ------- ------ -------------- --------------- ---------------
1 4830 OK 0 67 /u01/app/oracle11g/archivelog/1_4830_798551880.dbf
Finished validate at 2016-02-23 14:50:21

--理论讲这个不能对redo 的STATUS=CURRENT验证。不过可以作为一种补充方式。

正文到此结束