1. 整库备份
1.1 进入rman命令行
rman target / |
1.2开始备份
backup database;
Starting backup at 27-FEB-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=529 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=/oracle/u01/app/oracle/oradata/orcl/system01.dbf input datafile fno=00003 name=/oracle/u01/app/oracle/oradata/orcl/sysaux01.dbf input datafile fno=00005 name=/oracle/u01/app/oracle/oradata/orcl/admin01.dbf input datafile fno=00002 name=/oracle/u01/app/oracle/oradata/orcl/undotbs01.dbf input datafile fno=00004 name=/oracle/u01/app/oracle/oradata/orcl/users01.dbf channel ORA_DISK_1: starting piece 1 at 27-FEB-13 channel ORA_DISK_1: finished piece 1 at 27-FEB-13 piece handle=/oracle/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_02_27/o1_mf_nnndf_TAG20130227T165442_8lvlgm09_.bkp tag=TAG20130227T165442 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current control file in backupset including current SPFILE in backupset channel ORA_DISK_1: starting piece 1 at 27-FEB-13 channel ORA_DISK_1: finished piece 1 at 27-FEB-13 piece handle=/oracle/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_02_27/o1_mf_ncsnf_TAG20130227T165442_8lvlj116_.bkp tag=TAG20130227T165442 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 27-FEB-13 |
1.3说明
通过提示信息发现:
a) 生成两个备份集,一个存储所有数据文件,一个存储控制文件和参数文件
b) 默认存储在路径下
/oracle/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_02_27/
1.4指定存储位置
backup database format=’ /oracle/u01/app/oracle/backup/%U’; |
1.5查看备份信息
list backup of database;
List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 73 Full 963.45M DISK 00:00:38 27-FEB-13 BP Key: 73 Status: AVAILABLE Compressed: NO Tag: TAG20130227T170300 Piece Name: /oracle/u01/app/oracle/backup/2fo31kq4_1_1 List of Datafiles in backup set 73 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 5581557 27-FEB-13 /oracle/u01/app/oracle/oradata/orcl/system01.dbf 2 Full 5581557 27-FEB-13 /oracle/u01/app/oracle/oradata/orcl/undotbs01.dbf 3 Full 5581557 27-FEB-13 /oracle/u01/app/oracle/oradata/orcl/sysaux01.dbf 4 Full 5581557 27-FEB-13 /oracle/u01/app/oracle/oradata/orcl/users01.dbf 5 Full 5581557 27-FEB-13 /oracle/u01/app/oracle/oradata/orcl/admin01.dbf |
2. 表空间备份
2.1进入rman命令行
rman target / |
2.2开始备份
backup tablesapce users format='/oracle/u01/app/oracle/backup/U%';
Starting backup at 27-FEB-13 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00004 name=/oracle/u01/app/oracle/oradata/orcl/users01.dbf channel ORA_DISK_1: starting piece 1 at 27-FEB-13 channel ORA_DISK_1: finished piece 1 at 27-FEB-13 piece handle=/oracle/u01/app/oracle/backup/U% tag=TAG20130227T171029 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 27-FEB-13 |
2.3查看表空间备份
list backup of tablespace users; |
在提示信息中有多个,因为在全库备份时也备份了users表空间
3. 数据文件备份
3.1进入rman命令行
rman target / |
3.2开始备份
backup datafile ‘/oracle/u01/app/oracle/oradata/orcl/users01.dbf’ 或者 backup datafile 4; |
同样可以指定format
3.3说明
可以指定file_name和file_id
3.4查看
list backup of datafile n; |
4. 控制文件备份
4.1进入rman命令行
rman target / |
4.2开始备份
backup current controlfile; |
同样可以指定format
4.3设置自动备份控制文件
CONFIGURE CONTROLFILE AUTOBACKUP ON; |
4.4 plus archivelog的使用
backup current controlfile plus archivelog; |
执行过程:
a) 执行alter system archivelog current,对当前redolog进行归档
b) 执行backup archivelog all;备份所以已归档的日志
c) 执行backup对指定项备份
d) 再次执行alter system archivelog current;对当前redolog进行归档
e) 对新生成的尚未备份的归档进行备份
4.5说明
a) include current controlfile参数的使用,在备份任意文件时都可以指定此参数,用于备份控制文件,甚至可以在backup current controlfile 时指定参数。
b) 自动备份控制文件,在当参数为on时自动备份;另外对于备份中包括system.dbf时无论开启与否都会自动备份控制文件。
5. 归档文件备份
5.1进入rman命令行
rman target / |
5.2开始备份
backup archivelog all; |
同样可以指定format
5.3备份完成并删除不必要的归档
backup archivelog all delete input; |
这样在备份完成后会删除已备份的归档,节约空间。
6. 备份参数文件
6.1进入rman命令行
rman target / |
6.2开始备份
backup spfile; |
同样可以指定format
7. 备份备份集
7.1进入rman命令行
rman target / |
7.2开始备份
backup backupset all; |
同样可以指定format
7.3说明
a) 如果用all表示备份所有,可以指定备份哪个备份集,多个用逗号隔开
b) 指定从磁盘备份到磁盘,磁盘备份到磁带,不能从磁带备份到磁盘,磁带备份到磁带
c) 也可以指定delete input,用以删除,释放空间
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26252014/viewspace-754880/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26252014/viewspace-754880/