目录
一、前言 ............................................................................................................................................................. 3
二、Oracle 备份 ................................................................................................................................................ 3
1、Oracle 冷备 .............................................................................................................................................. 3
2、Oracle 热备 .............................................................................................................................................. 5
exp ............................................................................................................................................................... 5
expdp ........................................................................................................................................................... 6
rman ............................................................................................................................................................. 6
copy ........................................................................................................................................................... 17
三、Oracle 冷备恢复 ...................................................................................................................................... 21
四、Oracle 热备恢复 ...................................................................................................................................... 34
1、imp ........................................................................................................................................................... 34
2、impdp ....................................................................................................................................................... 34
3、rman ......................................................................................................................................................... 34
noarchive 模式 ........................................................................................................................................ 34
archive 模式 ............................................................................................................................................ 42
五、恢复 spfile .............................................................................................................................................. 53
1、从备份中恢复 spfile ............................................................................................................................ 53
2、从启动信息中获取 spfile .................................................................................................................... 59
3、从$ORACLE_HOME/dbs/init.ora 中获取参数文件 .............................................................................. 60
4、手动编辑 spfile .................................................................................................................................... 63
六、恢复 controlfile .................................................................................................................................... 63
1、冷备恢复 ................................................................................................................................................. 63
2、从备份中恢复控制文件 ......................................................................................................................... 63
3、基于数据文件生成控制文件 ................................................................................................................. 71
七、恢复数据文件 ........................................................................................................................................... 72
1、冷备恢复 ................................................................................................................................................. 72
2、rman 恢复 ................................................................................................................................................ 72
3、归档日志反写恢复数据文件 ................................................................................................................. 80
八、恢复 redo 文件 ......................................................................................................................................... 88
评论