Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

35

积分

0

好友

1

主题
1#
发表于 2012-7-13 13:36:12 | 查看: 3011| 回复: 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.
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 01:41 , Processed in 0.047610 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569