7备份与恢复基础之七 - ORACLE 备份与恢复最佳实践.pdf

ORACLE 恢复最佳实践 — 备份与恢复基础课程之七编号：XXX 课程目标 掌握Oracle 常见的错误分类及处理方案 从RMAN 入手了解数据库备份与恢复原理 掌握如何用爱数备份软件来做最佳的恢复 掌握爱数备份软件与oracle的内部交互机制 提纲 Oracle 错误分类  RMAN的备份与恢复 爱数备份软件最佳恢复方法 爱数备份软件内部交互机制 Oracle 的错误分类 不是所有的错误都需要恢复 Categories of Failures  Statement failure  User process failure  User error  Network failure  Instance failure  Media failure Categories of Failures Causes of Statement Failures  Logic error in an application  Attempt to enter invalid data into the table  Attempt an operation with insufficient privileges  Attempt to create a table but exceed allotted quota limits  Attempt an INSERT or UPDATE to a table, causing an extent to be allocated, but with insufficient free space available in the tablespace Categories of Failures Resolutions for Statement Failures  Correct the logical flow of the program  Modify and reissue the SQL statement  Provide the necessary database privileges  Change the user’s quota limit by using the ALTER USER command  Add file space to the tablespace  Enable resumable space allocation Categories of Failures Causes of User Process Failures  The user performed an abnormal disconnect in the session  The user’s session was abnormally terminated  The user’s program raised an address exception, which terminated the session Categories of Failures Resolution of User Process Failures  The PMON process detects an abnormally terminated user process  PMON rolls back the transaction and releases any resources and locks being held by it Categories of Failures Possible User Errors SQL DROP TABLE employees;