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'
作者: zhouyao800 时间: 2014-10-17 10:50
哪位老大能帮忙分析一下?作者: 笑脸松鼠 时间: 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