[bbk5357] 第85集 -第11章 -数据库诊断 01

Data Recovery Advisor

Reducing down time by eliminating confusion:

Data Failures

Data Failure:Examples

• Not accessible components,for example:
  • Missing data files at the OS level
  • Incorrect access permissions
  • Offline tablespace,and so on
• Physical corruptions,such as block checksum failures or invalid block header field values
• Logical corruptions,such as inconsistent dictionary,corrupt row piece,corrupt index entry,or corrupt transaction.
• Inconsistencies,such as control file is older or newer than the data files and online redo logs
• I/O failures,such as a limit on the number of open files exceeded,channels inaccessible,network or I/O error.

Data Recovery Advisor RMAN Command-Line Interface

RMAN Command	Action
LIST FAILURE	Lists previously executed failure assessment
ADVISE FAILURE	Displays recommended repair option
REPAIR FAILURE	Repairs and closes failures(after ADVISE in the same RAMN session)
CHANGE FAILURE	Changes or closes one or more failures