多按一下enter键引起的数据恢复失败！

informix数据库，用ontape恢复的时候用了很久时间都没有反应。通过onstat -u查看nwrites字段还在一直不停的增加，
说明此时数据还在不停的写，通过iostat 1查看，磁盘确实在写，但是磁带是没有亮的，说明没有从磁带中读取数据。

最后感觉可能是恢复的时候，嫌磁带读取信息的时候太慢，就多按了一下确定键，Continue restore? (y/n)Continue restore? (y/n)y
此时感觉应该是这个原因造成的。

经过测试，应该不是这个的原因！不过按两次enter键还是有问题的！

informix@tonykorn97:~> ontape -r

Please mount tape 1 on /dev/st1 and press Return to continue ...

Archive Tape Information

Tape type: Archive Backup Tape
Online version: IBM Informix Dynamic Server Version 10.00.UC4
Archive date: Tue Jan 2 03:08:40 2007
User id: informix
Terminal id: /dev/pts/1
Archive level: 0
Tape device: /dev/st0
Tape blocksize (in k): 32
Tape size (in k): 40960000
Tape number in series: 1

Spaces to restore:1 [rootdbs ]
2 [plogdbs ]
3 [llogdbs ]
4 [datadbs01 ]
5 [datadbs02 ]

Archive Information

IBM Informix Dynamic Server Copyright(C) 1986-2004 IBM Informix Software, Inc.
Initialization Time 09/11/2006 11:34:03
System Page Size 2048
Version 14
Archive CheckPoint Time 01/02/2007 03:08:41

Dbspaces
number flags fchunk nchunks flags owner name
1 40001 1 1 N B informix rootdbs
2 40001 2 1 N B informix plogdbs
3 40001 3 1 N B informix llogdbs
4 42001 4 2 N TB informix tempdbs1
5 42001 5 2 N TB informix tempdbs2
6 40001 6 1 N B informix datadbs01
7 40001 7 1 N B informix datadbs02

Chunks
chk/dbs offset size free bpages flags pathname
1 1 5 64000 59887 PO-B /informix.links/back/rootdbs
2 2 5 256000 447 PO-B /informix.links/back/plogdbs
3 3 5 512000 6947 PO-B /informix.links/back/llogdbs
4 4 5 512000 509397 PO-B /informix.links/back/tempdbs01
5 5 5 512000 509397 PO-B /informix.links/back/tempdbs02
6 6 5 2004000 1966547 PO-B /informix.links/back/datadbs01
7 7 5 37094000 26448678 PO-B /informix.links/back/datadbs02
8 4 0 256000 255997 PO-B /home/informix/tmpchunka
9 5 0 256000 255997 PO-B /home/informix/tmpchunkb

Continue restore? (y/n)Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n

informix@tonykorn97:~> onstat -u

IBM Informix Dynamic Server Version 10.00.UC4 -- Fast Recovery (CKPT REQ) -- Up 13:22:40 -- 217532 Kbytes
Blocked:CKPT

Userthreads
address flags sessid user tty wait tout locks nreads nwrites
4997b018 ---P--D 1 informix - 0 0 0 16 5
4997b544 ---P--F 0 informix - 0 0 0 0 0
4997ba70 ---P--- 5 informix - 0 0 0 0 0
4997bf9c ---P--B 6 informix - 0 0 0 0 0
4997c4c8 ---P--D 7 informix - 0 0 0 0 0
4997c9f4 Y--P--D 8 informix - 4407d138 0 0 0 0
4997cf20 Y--P--M 4 informix 7 4a098f28 0 0 0 0
4997d44c -----R- 4 informix 7 0 0 0 0 170043523
8 active, 128 total, 9 maximum concurrent

informix@tonykorn97:~> onstat -u

IBM Informix Dynamic Server Version 10.00.UC4 -- Fast Recovery (CKPT REQ) -- Up 13:35:45 -- 217532 Kbytes
Blocked:CKPT

Userthreads
address flags sessid user tty wait tout locks nreads nwrites
4997b018 ---P--D 1 informix - 0 0 0 16 5
4997b544 ---P--F 0 informix - 0 0 0 0 0
4997ba70 ---P--- 5 informix - 0 0 0 0 0
4997bf9c ---P--B 6 informix - 0 0 0 0 0
4997c4c8 ---P--D 7 informix - 0 0 0 0 0
4997c9f4 Y--P--D 8 informix - 4407d138 0 0 0 0
4997cf20 Y--P--M 4 informix 7 4a098f28 0 0 0 0
4997d44c -----R- 4 informix 7 0 0 0 0 172832195
8 active, 128 total, 9 maximum concurrent

日志信息：
18:59:20 DR: DRAUTO is 0 (Off)
18:59:20 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000
18:59:22 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

18:59:22 Data replication type and state information reset. To start DR, use
the 'onmode -d' command and wait for the pair to be operational,
before shutting down the database server

18:59:22 Dataskip is now OFF for all dbspaces
18:59:22 Restartable Restore has been ENABLED
18:59:22 Recovery Mode
18:59:24 Physical Restore of rootdbs, plogdbs, llogdbs, datadbs01, datadbs02 started.

Sat Apr 7 08:35:25 2007

08:35:25 Aborting physical restore of ROOT DBSpace
08:35:25 Aborted by client.
08:35:25 IBM Informix Dynamic Server Stopped.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/312079/viewspace-245638/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/312079/viewspace-245638/