checkcheck
SQL> select name from v$hm_check where internal_check='N';
NAME
----------------------------------------------------------------
DB Structure Integrity Check
CF Block Integrity Check
Data Block Integrity Check
Redo Integrity Check
Transaction Integrity Check
Undo Segment Integrity CheckSQL> begin
2 dbms_hm.run_check('Dictionary Integrity Check','Testrun');
3 end;
4 /
SQL> begin
2 dbms_hm.run_check('Dictionary Integrity Check','Testrun');
3 end;
4 /
PL/SQL procedure successfully completed.SQL> set long 100000
SQL> set longchunksize 1000
SQL> set pagesize 1000
SQL> set linesize 512
SQL> select dbms_hm.get_run_report('Testrun') from dual;
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Basic Run Information
Run Name : Testrun
Run Id : 761
Check Name : Dictionary Integrity Check
Mode : MANUAL
Status : COMPLETED
Start Time : 2023-12-29 21:08:40.062646 +05:30
End Time : 2023-12-29 21:08:41.580754 +05:30
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0
Input Parameters for the Run
TABLE_NAME=ALL_CORE_TABLES
CHECK_MASK=ALL
Run Findings And Recommendations
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 762
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: obj$.namespace 46 on object OBJ$
failed
Message : Damaged rowid is AAAAASAABAAAEBHAA7 - description: Object
Name SAAS is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 765
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: obj$.namespace 46 on object OBJ$
failed
Message : Damaged rowid is AAAAASAABAAAEBHAA6 - description: Object
Name PRIVATE_DBAAS is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 768
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: obj$.namespace 46 on object OBJ$
failed
Message : Damaged rowid is AAAAASAABAAAEBHAA8 - description: Object
Name PUBLIC_DBAAS is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 771
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: obj$.type# 47 on object OBJ$
failed
Message : Damaged rowid is AAAAASAABAAAEBHAA6 - description: Object
Name PRIVATE_DBAAS is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 774
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: obj$.type# 47 on object OBJ$
failed
Message : Damaged rowid is AAAAASAABAAAEBHAA7 - description: Object
Name SAAS is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 777
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: obj$.type# 47 on object OBJ$
failed
Message : Damaged rowid is AAAAASAABAAAEBHAA8 - description: Object
Name PUBLIC_DBAAS is referenced
SQL>
