Oracle backup and recovery overview

1、increase mean-time-between-failures mtbf ,decrease mean-time-to-recovery mttr
2、failures types:
          statement failure:语句错误，权限不足，空间不足
          user process failure:用户session被kill，程序有bug断开连接 》》pmon负责解决，无需手工干预
          user error:drop table，truncate，update等 》》培训程序员，从备份恢复，logminer，flashback，point-in-time recovery
          network failure:与数据库无关
          instance failure:断电》》无须手工干预，startup中smon自动恢复，查看alert_log日志 ( background_dump_dest) crash recovery successful
          media failure:磁盘损坏，读文件错误，文件误删》》取决于备份方法，有可能尽量用redolog恢复

 

 

风险评估，备份策略，测试计划