如何对Oracle进行健康检查

核心提示： SQL> SELECT name,internal_check,offline_capable,description FROM v$hm_check;NAME I O DESCRIPTION-- - - --HM Test Check Y Y Check for HM Functi

　　SQL> SELECT name,internal_check,offline_capable,description FROM v$hm_check;
　　NAME I O DESCRIPTION
　　------------------------------ - - ----------------------------------------------
　　HM Test Check Y Y Check for HM Functionality
　　DB Structure Integrity Check N Y Checks integrity of all database files
　　Data Block Integrity Check N Y Checks integrity of a datafile block
　　Redo Integrity Check N Y Checks integrity of redo log content
　　Logical Block Check Y N Checks logical content of a block
　　Transaction Integrity Check N N Checks a transaction for corruptions
　　Undo Segment Integrity Check N N Checks integrity of an undo segment
　　All Control Files Check Y Y Checks all control files in the database
　　CF Member Check Y Y Checks a multiplexed copy of the control file
　　All Datafiles Check Y Y Check for all datafiles in the database
　　Single Datafile Check Y Y Checks a datafile
　　Log Group Check Y Y Checks all members of a log group
　　Log Group Member Check Y Y Checks a particular member of a log group
　　Archived Log Check Y Y Checks an archived log
　　Redo Revalidation Check Y Y Checks redo log content
　　IO Revalidation Check Y Y Checks file accessability
　　Block IO Revalidation Check Y Y Checks file accessability
　　Txn Revalidation Check Y N Revalidate corrupted txn
　　Failure Simulation Check Y Y Creates dummy failures
　　Dictionary Integrity Check N N Checks dictionary integrity