ontape恢复的问题
本帖最后由 sqlnet 于 2010-02-11 18:36 编辑我有一个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:27Assert Failed: Page Check Error in next_scan:bad data page
18:11:27Informix Dynamic Server Version 7.31.UC7
18:11:27 Who: Session(26, informix@test, 26189, 1397237868)
Thread(50, xchg_2.0, 5345cc3c, 3)
File: rsdebug.c Line: 985
恢复日志:
17:18:47Event alarms enabled.ALARMPROG = '/usr/informix/etc/log_full.sh'
17:18:53DR: DRAUTO is 0 (Off)
17:18:53Informix Dynamic Server Version 7.31.UC7 Software Serial Number AAB#JXXXXXX
17:18:53Informix Dynamic Server Initialized -- Shared Memory Initialized.
17:18:53Dataskip is now OFF for all dbspaces
17:18:53Recovery Mode
17:20:08Physical Restore of rootdbs, logdbs, phydbs, datadbs started.
17:20:16Checkpoint Completed:duration was 0 seconds.
17:20:16Checkpoint Completed:duration was 0 seconds.
17:20:16Checkpoint Completed:duration was 0 seconds.
17:22:22Checkpoint Completed:duration was 0 seconds.
17:22:22Physical Restore of rootdbs, logdbs, phydbs, datadbs Completed.
17:22:22Checkpoint Completed:duration was 0 seconds.
17:24:02Physical Restore of rootdbs, logdbs, phydbs, datadbs started.
17:24:07Checkpoint Completed:duration was 0 seconds.
17:24:07Checkpoint Completed:duration was 0 seconds.
17:24:07Checkpoint Completed:duration was 0 seconds.
17:24:10Checkpoint Completed:duration was 0 seconds.
17:24:12Physical Restore of rootdbs, logdbs, phydbs, datadbs Completed.
17:24:12Checkpoint Completed:duration was 0 seconds.
17:34:22Physical Recovery Started.
17:34:22Physical Recovery Complete: 0 Pages Restored.
17:34:22Logical Recovery Started.
17:34:26Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
17:34:27Bringing system to Quiescent Mode with no Logical Restore.
17:34:28Quiescent Mode
17:34:28Logical Log 64 Complete.
17:34:28Checkpoint Completed:duration was 0 seconds.
17:34:32Process 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:34On-Line Mode
17:36:34Affinitied VP 3 to phys proc 2
17:36:34Affinitied VP 4 to phys proc 1
17:36:34Affinitied VP 1 to phys proc 1
17:38:01Assert Failed: Page Check Error in btpnext:bad page
17:38:01Informix 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 up一下 看看 点背不能怪社会~~:em26::em26:
表出问题了而已~ 表是没有问题的, 因为我在运行 ontape -s -l 1那台机器上查询都是完全正常的. 你的备份有问题！
你可以用archecker去检查一下！
怎么报有是页错误！
页:
[1]