鉴于映像备份需要占用和生产数据文件相同的空间,所以在数据量较大的情况下是不建议采用的,因为这种方案需要客户为花费双份存储
映像级别备份(image copies)相当于数据文件和归档日志的拷贝复制品,与原文件在存储空间上完全一致,如果需要做一个部分恢复(比如某一数据文件)采用映像备份情况下只需要检索相应的映像即可,恢复速度非常快,在某些非常情况下,可以直接switch到映像数据文件以保证生产环境尽可能短时间的停机,事后再做一个copy到原路径,选择空闲时段再次swich回去。
鉴于映像备份需要占用和生产数据文件相同的空间,所以在数据量较大的情况下是不建议采用的,因为这种方案需要客户为花费双份存储的钱,但是如果说在某库创建之初,数据文件不是很大,或者说某库数据量始终较小,那么选择影响备份是一种极好的方案,可以在数据文件出现物理损坏时,以最短的时间完成介质恢复。
下面介绍一些最简单的rman映像备份方案
1、开启rman块追踪技术
sql> alter database enable block change tracking using file '/u01/app/oralce/oradata/orcl/block_change_track_file.f';
database altered.
2、进行映像级别的level 0备份
run {
allocate channel ch1 device type disk format /u04/%u;
backup as copy tag 'base01'
incremental level 0
database;
}
3、进行映像级别的level 1备份
$ rman target /
run {
allocate channel ch1 device type disk format /u04/%u;
backup tag 'incr_update'
incremental level 1
database;
}
4、用level 1的备份update level 0 中的映像
run {
allocate channel ch1 device type disk format /u04/%u;
recover copy of database with tag 'base01';
}
实验纪录
1、level 0
rman> run {
allocate channel ch1 device type disk format /u04/%u;
backup as copy tag 'base01'
incremental level 0
database;
}
2> 3> 4> 5> 6>
released channel: ora_disk_1
allocated channel: ch1
channel ch1: sid=32 device type=disk
starting backup at 05-sep-13
channel ch1: starting datafile copy
input datafile file number=00001 name=/u01/app/oralce/oradata/orcl/system01.dbf
output file name=/u04/data_d-orcl_i-1349053318_ts-system_fno-1_0coj3jug tag=base01 recid=18 stamp=825348067
channel ch1: datafile copy complete, elapsed time: 00:00:25
channel ch1: starting datafile copy
input datafile file number=00002 name=/u01/app/oralce/oradata/orcl/sysaux01.dbf
output file name=/u04/data_d-orcl_i-1349053318_ts-sysaux_fno-2_0doj3jv9 tag=base01 recid=19 stamp=825348091
channel ch1: datafile copy complete, elapsed time: 00:00:25
channel ch1: starting datafile copy
input datafile file number=00005 name=/u01/app/oralce/oradata/orcl/example01.dbf
output file name=/u04/data_d-orcl_i-1349053318_ts-example_fno-5_0eoj3k02 tag=base01 recid=20 stamp=825348107
channel ch1: datafile copy complete, elapsed time: 00:00:15
channel ch1: starting datafile copy
input datafile file number=00004 name=/u01/app/oralce/oradata/orcl/users01.dbf
output file name=/u04/data_d-orcl_i-1349053318_ts-users_fno-4_0foj3k0h tag=base01 recid=21 stamp=825348116
channel ch1: datafile copy complete, elapsed time: 00:00:03
channel ch1: starting datafile copy
input datafile file number=00003 name=/u01/app/oralce/oradata/orcl/undotbs01.dbf
output file name=/u04/data_d-orcl_i-1349053318_ts-undotbs1_fno-3_0goj3k0l tag=base01 recid=22 stamp=825348120
channel ch1: datafile copy complete, elapsed time: 00:00:07
finished backup at 05-sep-13
starting control file and spfile autobackup at 05-sep-13
piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1349053318-20130905-00 comment=none
finished control file and spfile autobackup at 05-sep-13
released channel: ch1
rman>
更多详情见请继续阅读下一页的精彩内容:
推荐阅读:
oracle基础教程之通过rman复制数据库
rman备份策略制定参考内容
rman备份学习笔记
oracle数据库备份加密 rman加密
,