免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 5387 | 回复: 4

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

论坛徽章:
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
发表于 2015-05-15 11:12 |显示全部楼层
还有一个问题,加入我刚上NBU备份,没有做0级别的备份,从1级备份开始备份,,那么NBU备份会忽略1级备份直接备份0级吗???

论坛徽章:
0
发表于 2015-05-15 11:33 |显示全部楼层
本帖最后由 aiaix1211 于 2015-05-15 11:35 编辑

还发现一下问题
QQ截图20150515113301.png

论坛徽章:
197
15-16赛季CBA联赛之上海
日期:2019-09-11 11:39:5315-16赛季CBA联赛之青岛
日期:2018-08-08 11:17:1915-16赛季CBA联赛之广夏
日期:2018-03-01 16:41:0915-16赛季CBA联赛之浙江
日期:2017-12-28 14:13:38黑曼巴
日期:2017-12-11 12:52:0315-16赛季CBA联赛之吉林
日期:2017-12-11 12:51:5915-16赛季CBA联赛之天津
日期:2017-10-30 09:57:35CU十四周年纪念徽章
日期:2017-10-13 17:10:0215-16赛季CBA联赛之福建
日期:2017-05-11 14:36:1515-16赛季CBA联赛之四川
日期:2017-04-26 19:47:1615-16赛季CBA联赛之同曦
日期:2017-03-08 08:45:47CU十四周年纪念徽章
日期:2017-03-03 10:14:32
发表于 2015-05-15 17:00 |显示全部楼层
oracet备份可以选择一周做一次全备份(就是楼主所说的0级备份)一周其它的时间只要做归档日志的备份就可以了(归档日志备份完就自动删除)

论坛徽章:
0
发表于 2015-05-15 20:36 |显示全部楼层
回复 4# yoyosys
我的这个问题可以解决吗?


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

本版积分规则 发表回复

SACC2019中国系统架构师大会

【数字转型 架构演进】SACC2019中国系统架构师大会,8.5折限时优惠重磅来袭!
2019年10月31日~11月2日第11届中国系统架构师大会(SACC2019)将在北京隆重召开。四大主线并行的演讲模式,1个主会场、20个技术专场、超千人参与的会议规模,100+来自互联网、金融、制造业、电商等领域的嘉宾阵容,将为广大参会者提供一场最具价值的技术交流盛会。

限时8.5折扣期:2019年9月30日前


----------------------------------------

大会官网>>
  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP