免费注册 查看新帖 |

Chinaunix

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

[Veritas NBU] NBU ORACLE 恢复报错 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2014-10-17 08:59 |只看该作者 |倒序浏览
NBU  ORACLE 本地备份后,建的重删池,replacation到异地服务器,异地恢复数据库,每天恢复,原来一直是成功的,昨天出现报错,能给帮忙分析一下吗?环境为aix上的oracle10g报错日志如下:拷贝的restor.sh.out
RMAN: /oracle/product/10.2.0/bin/rman
ORACLE_SID: tjtsyw
ORACLE_USER: oracle
ORACLE_HOME: /oracle/product/10.2.0

Recovery Manager: Release 10.2.0.3.0 - Production on Thu Oct 16 12:16:08 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: TJTSYW (DBID=2518181690, not open)
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> RMAN> 2> 3> 4> 5>
6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17>
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started

Total System Global Area    1610612736 bytes

Fixed Size                     2073192 bytes
Variable Size                335547800 bytes
Database Buffers            1258291200 bytes
Redo Buffers                  14700544 bytes

allocated channel: ch00
channel ch00: sid=1642 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2012020807)

sent command to channel: ch00

sent command to channel: ch00

Starting restore at 16-OCT-14

channel ch00: restoring control file
channel ch00: restore complete, elapsed time: 00:00:26
output filename=/oradata/tjtsyw/control01.ctl
output filename=/oradata/tjtsyw/control02.ctl
output filename=/oradata/tjtsyw/control03.ctl
Finished restore at 16-OCT-14

released channel: ch00

database mounted

allocated channel: ch02
channel ch02: sid=1642 devtype=SBT_TAPE
channel ch02: Veritas NetBackup for Oracle - Release 7.5 (2012020807)

sent command to channel: ch02

sent command to channel: ch02

Starting restore at 16-OCT-14
Starting implicit crosscheck backup at 16-OCT-14
Finished implicit crosscheck backup at 16-OCT-14

Starting implicit crosscheck copy at 16-OCT-14
Finished implicit crosscheck copy at 16-OCT-14

searching for all files in the recovery area
cataloging files...
no files cataloged


skipping datafile 2; already restored to file /oradata/tjtsyw/undotbs01.dbf
skipping datafile 3; already restored to file /oradata/tjtsyw/sysaux01.dbf
skipping datafile 1; already restored to file /oradata/tjtsyw/system01.dbf
skipping datafile 4; already restored to file /oradata/tjtsyw/users01.dbf
skipping datafile 5; already restored to file /oradata/tjtsyw/tbs_users.dbf
dbfpping datafile 6; already restored to file /oradata/tjtsyw/dynamicpces_idx01.
.dbfping datafile 8; already restored to file /oradata/tjtsyw/tjtsyw_staticspace
channel ch02: starting datafile backupset restore
channel ch02: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /oradata/tjtsyw/staticspace_idx01.dbf
restoring datafile 00009 to /oradata/tjtsyw/tjtsyw_dynamicpces.dbf
restoring datafile 00010 to /oradata/tjtsyw/tbs_users01.dbf
channel ch02: reading from backup piece bk_5731_1_860695310
ORA-19870: error reading backup piece bk_5731_1_860695310
(blocksize=8192)error on file "/oradata/tjtsyw/tbs_users01.dbf", blockno 405425
ORA-27063: number of bytes read/written is incorrect
.BM AIX RISC System/6000 Error: 28: There is not enough space in the file system
Additional information: -1
Additional information: 131072
failover to previous backup

channel ch02: starting datafile backupset restore
channel ch02: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /oradata/tjtsyw/staticspace_idx01.dbf
restoring datafile 00009 to /oradata/tjtsyw/tjtsyw_dynamicpces.dbf
restoring datafile 00010 to /oradata/tjtsyw/tbs_users01.dbf
channel ch02: reading from backup piece bk_5682_1_860090509
ORA-19870: error reading backup piece bk_5682_1_860090509
(blocksize=8192)error on file "/oradata/tjtsyw/tbs_users01.dbf", blockno 405425
ORA-27063: number of bytes read/written is incorrect
.BM AIX RISC System/6000 Error: 28: There is not enough space in the file system
Additional information: -1
Additional information: 131072
failover to previous backup

channel ch02: starting datafile backupset restore
channel ch02: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /oradata/tjtsyw/staticspace_idx01.dbf
restoring datafile 00009 to /oradata/tjtsyw/tjtsyw_dynamicpces.dbf
restoring datafile 00010 to /oradata/tjtsyw/tbs_users01.dbf
channel ch02: reading from backup piece bk_5654_1_859672310
ORA-19870: error reading backup piece bk_5654_1_859672310
(blocksize=8192)error on file "/oradata/tjtsyw/tbs_users01.dbf", blockno 405425



原来成功的时候,restore成功以后,敲alter database open resetlogs;就能成功打开,现在是控制文件和数据文件不一致了。
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oradata/tjtsyw/system01.dbf'

论坛徽章:
0
2 [报告]
发表于 2014-10-17 10:50 |只看该作者
哪位老大能帮忙分析一下?

论坛徽章:
0
3 [报告]
发表于 2014-10-21 19:58 |只看该作者
ORA-19870: error reading backup piece bk_5731_1_860695310
(blocksize=8192)error on file "/oradata/tjtsyw/tbs_users01.dbf", blockno 405425
ORA-27063: number of bytes read/written is incorrect
.BM AIX RISC System/6000 Error: 28: There is not enough space in the file system
Additional information: -1
Additional information: 131072
failover to previous backup

空间不足.......

论坛徽章:
0
4 [报告]
发表于 2014-10-27 15:24 |只看该作者
空间不足?我也看了那个报错,是哪个空间不足啊,我看了服务器的各个目录都有剩余空间百分之70以上啊
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP