测试环境:
操作系统:windows7(32bit)
ORACLE版本:11.2g
一、完整备份整个数据库
操作前准备:
SQL>host rman---启动RMAN
RMAN>connect catalog rman/123456@catalog;---连接恢复目录数据库
RMAN>connect target sys/123456@warehouse;---连接目标数据库
备份整个数据库(包括数据文件、控制文件、实例参数文件、归档日志文件)
RMAN> RUN
2> {
3> allocate channel c1 device type disk;
4> allocate channel c2 device type disk;
5> allocate channel c3 device type disk;
6> allocate channel c4 device type disk;
7> backup as backupset
8> copies 1
9> database plus archivelog
10> format "G:\Oracle\backup\warehouse\full_backup_%d_%u"
11>