ontape恢复的问题

sqlnet

我有一个0级和1级备份,ontape -r 恢复了0级,然后恢复了1级,没有备份和恢复日志,onmode -my后查看相关表 只恢复了 0级的数据,而查询某些大表,直接报错.
18:10:27   Results: Possible inconsistencies in 'test:"test".test'
18:10:27   Action: Run 'oncheck -cD 5243036'
18:10:29   See Also: /tmp/af.41a8e23, shmem.41a8e23.1
18:11:27  Assert Failed: Page Check Error in next_scan:bad data page
18:11:27  Informix Dynamic Server Version 7.31.UC7   
18:11:27   Who: Session(26, informix@test, 26189, 139723786
                Thread(50, xchg_2.0, 5345cc3c, 3)
                File: rsdebug.c Line: 985

恢复日志:

17:18:47  Event alarms enabled.  ALARMPROG = '/usr/informix/etc/log_full.sh'
17:18:53  DR: DRAUTO is 0 (Off)
17:18:53  Informix Dynamic Server Version 7.31.UC7    Software Serial Number AAB#JXXXXXX
17:18:53  Informix Dynamic Server Initialized -- Shared Memory Initialized.
17:18:53  Dataskip is now OFF for all dbspaces
17:18:53  Recovery Mode
17:20:08  Physical Restore of rootdbs, logdbs, phydbs, datadbs started.

17:20:16  Checkpoint Completed:  duration was 0 seconds.
17:20:16  Checkpoint Completed:  duration was 0 seconds.
17:20:16  Checkpoint Completed:  duration was 0 seconds.
17:22:22  Checkpoint Completed:  duration was 0 seconds.
17:22:22  Physical Restore of rootdbs, logdbs, phydbs, datadbs Completed.
17:22:22  Checkpoint Completed:  duration was 0 seconds.
17:24:02  Physical Restore of rootdbs, logdbs, phydbs, datadbs started.

17:24:07  Checkpoint Completed:  duration was 0 seconds.
17:24:07  Checkpoint Completed:  duration was 0 seconds.
17:24:07  Checkpoint Completed:  duration was 0 seconds.
17:24:10  Checkpoint Completed:  duration was 0 seconds.
17:24:12  Physical Restore of rootdbs, logdbs, phydbs, datadbs Completed.
17:24:12  Checkpoint Completed:  duration was 0 seconds.
17:34:22  Physical Recovery Started.
17:34:22  Physical Recovery Complete: 0 Pages Restored.
17:34:22  Logical Recovery Started.
17:34:26  Logical Recovery Complete.
        0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

17:34:27  Bringing system to Quiescent Mode with no Logical Restore.

17:34:28  Quiescent Mode
17:34:28  Logical Log 64 Complete.
17:34:28  Checkpoint Completed:  duration was 0 seconds.
17:34:32  Process exited with return code 142: /bin/sh /bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 64 Complete." "Logical Log 64 Complete."
17:36:34  On-Line Mode
17:36:34  Affinitied VP 3 to phys proc 2
17:36:34  Affinitied VP 4 to phys proc 1
17:36:34  Affinitied VP 1 to phys proc 1
17:38:01  Assert Failed: Page Check Error in btpnext:bad page
17:38:01  Informix Dynamic Server Version 7.31.UC7   
17:38:01   Who: Session(18, informix@test, 25678, 1397237512)
                Thread(39, sqlexec, 5345b89c, 3)
                File: rsdebug.c Line: 1036
17:38:01   Results: Possible inconsistencies in 'test:"test".test'
17:38:01   Action: Run 'oncheck -cDI test:"test".test'
17:38:08   See Also: /tmp/af.40f86c9, shmem.40f86c9.0

sqlnet

up一下 看看

liaosnet

点背不能怪社会~~

表出问题了而已~

sqlnet

表是没有问题的,   因为我在运行 ontape -s -l 1那台机器上查询都是完全正常的.

大梦

你的备份有问题！
你可以用archecker去检查一下！
怎么报有是页错误！