oracle 异机恢复报错

[zhouyao800]

异机恢复数据库，每天恢复，原来一直是成功的，昨天出现报错，能给帮忙分析一下吗？环境为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'

[huangdh12]

不是提示比较清楚，system01恢复的时候不是有效的。 system01 文件没有restore成功吧

[bw555]

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 不只是那一个文件，在recovery区域没找到任何文件 后面全都跳过了

[zhouyao800]

那这个我要怎么操作 才能恢复数据库呢？

[zhouyao800]

哪位大神给解答一下啊？

[小灰狼W]

引用 2 楼 bw555 的回复:

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 不只是那一个文件，在recovery区域没找到任何文件 后面全都跳过了

不是这样的，恢复的时候，会根据控制文件和数据文件的信息来比较备份集与当前数据文件的scn，确定是否需要restore 这里是正常的 但是，进行不完全恢复，除了restore，还需要有个recover的过程，使得数据文件处于一直的状态，才能进行open 这里缺少了这一步，因此启动会出错 restore其实并不成功，关注下这个错误 ORA-19870: error reading backup piece bk_5654_1_859672310 (blocksize=8192)error on file "/oradata/tjtsyw/tbs_users01.dbf", blockno 405425 检查磁盘空间是否充足