多按一下enter鍵引起的資料恢復失敗!

tonykorn97發表於2007-04-07

informix資料庫,用ontape恢復的時候用了很久時間都沒有反應。透過onstat -u檢視nwrites欄位還在一直不停的增加,
說明此時資料還在不停的寫,透過iostat 1檢視,磁碟確實在寫,但是磁帶是沒有亮的,說明沒有從磁帶中讀取資料。

最後感覺可能是恢復的時候,嫌磁帶讀取資訊的時候太慢,就多按了一下確定鍵,Continue restore? (y/n)Continue restore? (y/n)y
此時感覺應該是這個原因造成的。

經過測試,應該不是這個的原因!不過按兩次enter鍵還是有問題的!


:~> 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


:~> 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

:~> 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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章