免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 6062 | 回复: 4
打印 上一主题 下一主题

[备份软件] NBU数据备份异常 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2015-05-15 10:29 |只看该作者 |倒序浏览
本帖最后由 aiaix1211 于 2015-05-15 10:30 编辑

5.14日对数据库做了1级增量备份,备份文件大小37G,时间大概花了3小时, 5.15日还是增量1级,时间花了6小时还没有备份完成,日志也是正常的,15日的日志如下:
Script /usr/openv/netbackup/scripts/dbrisk_rman.sh
==== started on Fri May 15 02:59:59 CST 2015 ====


RMAN: /opt/u01/app/oracle/product/11.2.0/db_1/bin/rman
ORACLE_SID: dbora001
ORACLE_USER: oracle
ORACLE_HOME: /opt/u01/app/oracle/product/11.2.0/db_1

NB_ORA_FULL: 0
NB_ORA_INCR: 1
NB_ORA_CINC: 0
NB_ORA_SERV: nbu01
NB_ORA_POLICY: db_backup

Differential incremental backup requested

Recovery Manager: Release 11.2.0.3.0 - Production on Fri May 15 02:59:59 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: dbora001 (DBID=61376923)
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49>
allocated channel: ch00
channel ch00: SID=669 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.6 (2014102721)

allocated channel: ch01
channel ch01: SID=635 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.6 (2014102721)

sent command to channel: ch00
sent command to channel: ch01

Starting backup at 15-MAY-15
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 4 found
channel ch00: starting compressed incremental level 1 datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00008 name=/opt/u01/app/oracle/oradata/dbora001/DB01.dbf
input datafile file number=00029 name=/opt/u01/app/oracle/oradata/dbora001/DBss10.dbf
input datafile file number=00051 name=/opt/u01/app/oracle/oradata/dbora001/DBdd1.dbf
input datafile file number=00073 name=/opt/u01/app/oracle/oradata/dbora001/DBaa38.dbf
input datafile file number=00093 name=/opt/u01/app/oracle/oradata/dbora001/DBcc08.dbf
channel ch00: starting piece 1 at 15-MAY-15
channel ch01: starting compressed incremental level 1 datafile backup set
channel ch01: specifying datafile(s) in backup set
input datafile file number=00009 name=/opt/u01/app/oracle/oradata/dbora001/aa.dbf
input datafile file number=00030 name=/opt/u01/app/oracle/oradata/dbora001/bb.dbf
input datafile file number=00052 name=/opt/u01/app/oracle/oradata/dbora001/cc.dbf
input datafile file number=00074 name=/opt/u01/app/oracle/oradata/dbora001/dd.dbf
input datafile file number=00094 name=/opt/u01/app/oracle/oradata/dbora001/aa.dbf
channel ch01: starting piece 1 at 15-MAY-15
channel ch00: finished piece 1 at 15-MAY-15
piece handle=bk_2058_1_879735604 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:27:36
channel ch00: starting compressed incremental level 1 datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00010 name=/opt/u01/app/oracle/oradata/dbora001/dd.dbf
input datafile file number=00031 name=/opt/u01/app/oracle/oradata/dbora001/dd.dbf
input datafile file number=00053 name=/opt/u01/app/oracle/oradata/dbora001/dd.dbf
input datafile file number=00075 name=/opt/u01/app/oracle/oradata/dbora001/dd.dbf
input datafile file number=00095 name=/opt/u01/app/oracle/oradata/dbora001/dd.dbf
channel ch00: starting piece 1 at 15-MAY-15
channel ch01: finished piece 1 at 15-MAY-15
piece handle=bk_2059_1_879735604 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:56:02
channel ch01: starting compressed incremental level 1 datafile backup set
channel ch01: specifying datafile(s) in backup set
input datafile file number=00011 name=/opt/u01/app/oracle/oradata/dbora001/aaa01.dbf
input datafile file number=00032 name=/opt/u01/app/oracle/oradata/dbora001/bbb07.dbf
input datafile file number=00054 name=/opt/u01/app/oracle/oradata/dbora001/ccc23.dbf
input datafile file number=00076 name=/opt/u01/app/oracle/oradata/dbora001/ddd18.dbf
input datafile file number=00096 name=/opt/u01/app/oracle/oradata/dbora001/aaa49.dbf
channel ch01: starting piece 1 at 15-MAY-15
channel ch00: finished piece 1 at 15-MAY-15
piece handle=bk_2060_1_879737261 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 01:04:32
channel ch00: starting compressed incremental level 1 datafile backup set

后面也没有报错,,查看已经备份出来的文件竟然有110G,早上因业务问题就取消的备份,,各位备份的朋友有碰到过这样的问题吗。 1级别是增量1级别。

论坛徽章:
0
2 [报告]
发表于 2015-05-15 11:12 |只看该作者
还有一个问题,加入我刚上NBU备份,没有做0级别的备份,从1级备份开始备份,,那么NBU备份会忽略1级备份直接备份0级吗???

论坛徽章:
0
3 [报告]
发表于 2015-05-15 11:33 |只看该作者
本帖最后由 aiaix1211 于 2015-05-15 11:35 编辑

还发现一下问题

QQ截图20150515113301.png (19.45 KB, 下载次数: 122)

QQ截图20150515113301.png

论坛徽章:
221
15-16赛季CBA联赛之吉林
日期:2017-12-11 12:51:59黑曼巴
日期:2019-04-12 13:40:0515-16赛季CBA联赛之广东
日期:2019-04-23 10:41:1215-16赛季CBA联赛之辽宁
日期:2019-05-06 13:03:2815-16赛季CBA联赛之山西
日期:2019-05-09 10:56:5815-16赛季CBA联赛之青岛
日期:2019-05-17 13:57:0515-16赛季CBA联赛之新疆
日期:2019-06-10 13:39:0515-16赛季CBA联赛之天津
日期:2019-07-08 15:04:4519周年集字徽章-19
日期:2019-08-27 13:31:2619周年集字徽章-19
日期:2019-08-27 13:31:2619周年集字徽章-周
日期:2019-09-06 18:46:4715-16赛季CBA联赛之天津
日期:2019-02-27 11:24:07
4 [报告]
发表于 2015-05-15 17:00 |只看该作者
oracet备份可以选择一周做一次全备份(就是楼主所说的0级备份)一周其它的时间只要做归档日志的备份就可以了(归档日志备份完就自动删除)

论坛徽章:
0
5 [报告]
发表于 2015-05-15 20:36 |只看该作者
回复 4# yoyosys
我的这个问题可以解决吗?


   
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP