Oracle 9i RMAN参考使用手册
作者概述：
陈吉平，网络ID 为piner，现在任职于淘宝网(
www.taobao.com)，主要负责网站后台数
据库维护，擅长
备份与恢复，数据库高可用性与容灾，对数据库优化也有很深的研究。希望
能广交oracle朋友，共同进步。
本人所有文章，不经许可，不得转载。
概述.................................................................................................................................................2
一、RMAN 的概念与体系结构......................................................................................................2
二、启动与运行RMAN..................................................................................................................4
2.1 运行要求...........................................................................................................................4
2.2 基本运行方法...................................................................................................................4
2.3 怎么样运行RMAN命令.......................................................................................................5
三、RMAN 的自动配置..................................................................................................................6
3.1 备份策略保持...................................................................................................................6
3.2 通道配置与自动通道分配.................................................................................................6
3.3 控制文件自动备份............................................................................................................7
3.4 设置并行备份....................................................................................................................7
3.5 配置默认IO 设备类型.......................................................................................................7
3.6 配置多个备份的拷贝数目.................................................................................................8
3.7 备份优化............................................................................................................................8
3.8 备份文件的格式................................................................................................................8
四、用RMAN 备份........................................................................................................................8
4.1 文件拷贝............................................................................................................................9
4.2 备份与备份集....................................................................................................................9
4.3 常见备份参数.................................................................................................................10
4.4 增量备份..........................................................................................................................10
4.5 备份检查..........................................................................................................................12
4.6 重新启动备份..................................................................................................................12
4.7 RMAN 动态
性能视图.....................................................................................................12
五、还原与恢复............................................................................................................................13
5.1 常规还原与恢复..............................................................................................................13
5.2 特殊情况下的恢复..........................................................................................................14
5.3 还原检查与恢复测试.......................................................................................................14
5.4 块级别的恢复..................................................................................................................15
5.5 数据库复制......................................................................................................................15
5.6 利用RMAN 创建备用数据库.........................................................................................16
六、RMAN 的管理.......................................................................................................................17
6.1Report命令........................................................................................................................17
6.2 List命令...........................................................................................................................17
2
6.3 Crosscheck命令...............................................................................................................18
6.4 Delete 命令......................................................................................................................18
七、恢复目录................................................................................................................................18
7.1 创建恢复目录..................................................................................................................19
7.2 恢复目录管理..................................................................................................................19
7.3 恢复目录视图..................................................................................................................19
7.4
存储脚本..........................................................................................................................20
小节...............................................................................................................................................20
附录...............................................................................................................................................20
