- 最后登录
- 2014-1-20
- 在线时间
- 8 小时
- 威望
- 35
- 金钱
- 314
- 注册时间
- 2012-3-8
- 阅读权限
- 10
- 帖子
- 34
- 精华
- 0
- 积分
- 35
- UID
- 285
|
1#
发表于 2012-7-13 13:36:12
|
查看: 3041 |
回复: 0
OS:Cent OS 6.0Version :11.2.0.1
问题描述:
rman增量备份,做的差异增量备份。
备份策略为: 每月1号,0级备份; 7,14,21,28做 1级备份。 其他时间都做2级备份。
看这个月的备份情况,发现问题了。
1号做的0级备份, 生成备份文件100G
每天的2级备份,文件大小约10G
7号的1级备份,文件大小约18G
结果 到11号,还是2级备份,产生的备份文件竟然跟 0级备份一样,为100G。
看日志,的确是做的2级备份。
请教这是怎么回事??
日志如下:
Starting backup at 11-JUL-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=197 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1154 device type=DISK
channel ORA_DISK_1: starting incremental level 2 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/oracle/oradata/DB1/dbfile01.dbf
input datafile file number=00005 name=/oracle/oradata/DB1/dbfile03.dbf
input datafile file number=00001 name=/oracle/oradata/DB1/system01.dbf
input datafile file number=00002 name=/oracle/oradata/DB1/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 11-JUL-12
channel ORA_DISK_2: starting incremental level 2 datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00004 name=/oracle/oradata/DB1/dbfile02.dbf
input datafile file number=00008 name=/oracle/oradata/DB1/dbfile04.dbf
input datafile file number=00003 name=/oracle/oradata/HANDPET/undotbs01.dbf
channel ORA_DISK_2: starting piece 1 at 11-JUL-12
channel ORA_DISK_1: finished piece 1 at 11-JUL-12
piece handle=/oracle/rman_data/DB1/datafile_bak/backup_DB1_275_1_8jnfpo1m_1_1.bak tag=TAG20120711T030005 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:28:17
channel ORA_DISK_2: finished piece 1 at 11-JUL-12
piece handle=/oracle/rman_data/DB1/datafile_bak/backup_DB1_276_1_8knfpo25_1_1.bak tag=TAG20120711T030005 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:29:13
Finished backup at 11-JUL-12
Starting Control File and SPFILE Autobackup at 11-JUL-12
piece handle=/oracle/rman_data/DB1/ctl_bak/ctl_pfile_c-2504578909-20120711-00 comment=NONE
Finished Control File and SPFILE Autobackup at 11-JUL-12
Recovery Manager complete. |
|