在對(duì)數(shù)據(jù)庫恢復(fù)之前欧芽，需要保證數(shù)據(jù)庫的安裝程序男韧、環(huán)境變量朴摊，原數(shù)據(jù)庫的所有數(shù)據(jù)文件以及日志空間的名字、容量此虑、權(quán)限與恢復(fù)之前相同甚纲。

onbar -r -p dbspace_name
恢復(fù)全部數(shù)據(jù)文件，但不做邏輯日志的恢復(fù)和應(yīng)用朦前，也可以只恢復(fù)某表空間

onbar -r –l
在前一個(gè)命令的基礎(chǔ)上介杆，做邏輯日志恢復(fù)

onbar -r [dbspace_name]
恢復(fù)全部數(shù)據(jù)文件，包括邏輯日志的恢復(fù)和應(yīng)用韭寸，也可以只恢復(fù)某表空間

onbar -r -t time -w –p
整體數(shù)據(jù)庫的時(shí)間點(diǎn)的恢復(fù)春哨。

如果數(shù)據(jù)庫全部損壞，則需要恢復(fù)如下文件：
根據(jù)您的備份規(guī)劃恩伺，您可以執(zhí)行如下通過管理頁面執(zhí)行：
進(jìn)入恢復(fù)頁面：/usr/openv/netbackup/bin/jbpSA &
選擇你要恢復(fù)的數(shù)據(jù)庫備份文件 $INFORMIXDIR/etc/ 等
如果恢復(fù)時(shí)有未曾備份的邏輯日志赴背，則需要拯救當(dāng)前的日志文件：
onbar -l -s
然后執(zhí)行：
onbar -r
恢復(fù)過程中，都可以查看恢復(fù)日志 bar_act.log

如主機(jī)宕機(jī)莫其，在環(huán)境一樣的備機(jī)上進(jìn)行全庫的實(shí)例恢復(fù)：
確認(rèn)informix處于關(guān)閉狀態(tài)
$ onstat -
shared memory not initialized for INFORMIXSERVER 'xxx_tcp'
設(shè)置請(qǐng)求恢復(fù)的數(shù)據(jù)源為xxx主機(jī)的備份集
$ export INFXBSA_CLIENT=xxx
進(jìn)行onbar恢復(fù)癞尚，根據(jù)需要使用onbar參數(shù)
$ onbar -r -w -p

開始恢復(fù)后在NBU Admin Console（jnbSA&）可以看到恢復(fù)任務(wù)
同時(shí)查看日志

cd db/informix/tmp

tail -f bar_act.log

-c  Use compression dictionary to expand compressed data
-q  Do not display program header
-b  Display information about logged BLOB pages
-u  Display the specified user(s)
-t  Display the specified TBLspace(s)
-x  Display the specified transaction(s)

2015-01-31 01:16:30 23285 23283 /home/db/informix/bin/onbar_d complete, returning 149
(0x95)
2015-01-31 01:32:40 6762 6760 /home/db/informix/bin/onbar_d -r -w -p
2015-01-31 01:32:40 6762 6760 Working with veritas-netbackup as generic storage
manager.
2015-01-31 01:32:41 6762 6760 Successfully connected to Storage Manager.
2015-01-31 01:36:28 6762 6760 Begin reserved pages restore (level 0 of rootdbs, Storage
Manager copy ID: 1 1422538816).
2015-01-31 01:36:38 6762 6760 Completed reserved pages restore (level 0 of rootdbs).
2015-01-31 01:36:40 6762 6760 (-43341) Logical log 28621 is needed by this restore but
cannot be found in OnBar ixbar file.
2015-01-31 01:36:40 6762 6760 Successfully connected to Storage Manager.
2015-01-31 01:40:50 6762 6760 Begin cold level 0 restore rootdbs (Storage Manager copy
ID: 1 1422538816).
2015-01-31 01:41:11 6762 6760 Completed cold level 0 restore rootdbs.
2015-01-31 01:43:42 6762 6760 Begin cold level 0 restore blobdbs (Storage Manager copy
ID: 1 1422539009).
2015-01-31 01:43:52 6762 6760 Completed cold level 0 restore blobdbs.
2015-01-31 01:46:37 6762 6760 Begin cold level 0 restore ywdattbs02 (Storage Manager
copy ID: 1 1422539175).
2015-01-31 01:49:07 6762 6760 Completed cold level 0 restore ywdattbs02.
2015-01-31 01:51:33 6762 6760 Begin cold level 0 restore ywdattbs08 (Storage Manager
copy ID: 1 1422540977).
2015-01-31 01:53:51 6762 6760 Completed cold level 0 restore ywdattbs08.
2015-01-31 01:56:27 6762 6760 Begin cold level 0 restore ywdattbs04 (Storage Manager
copy ID: 1 1422542465).
2015-01-31 01:58:44 6762 6760 Completed cold level 0 restore ywdattbs04.
2015-01-31 02:01:25 6762 6760 Begin cold level 0 restore ywdattbs07 (Storage Manager
copy ID: 1 1422543766).
2015-01-31 02:03:31 6762 6760 Completed cold level 0 restore ywdattbs07.
2015-01-31 02:05:56 6762 6760 Begin cold level 0 restore ywdattbs01 (Storage Manager
copy ID: 1 1422545053).
2015-01-31 02:08:01 6762 6760 Completed cold level 0 restore ywdattbs01.
2015-01-31 02:10:27 6762 6760 Begin cold level 0 restore ywdattbs03 (Storage Manager
copy ID: 1 1422546320).
2015-01-31 02:12:31 6762 6760 Completed cold level 0 restore ywdattbs03.
2015-01-31 02:14:41 6762 6760 Begin cold level 0 restore data0tbs01 (Storage Manager
copy ID: 1 1422547639).
2015-01-31 02:16:45 6762 6760 Completed cold level 0 restore data0tbs01.
2015-01-31 02:19:16 6762 6760 Begin cold level 0 restore ywdattbs05 (Storage Manager
copy ID: 1 1422548920).
2015-01-31 02:21:14 6762 6760 Completed cold level 0 restore ywdattbs05.
2015-01-31 02:23:05 6762 6760 Begin cold level 0 restore ywdattbs06 (Storage Manager
copy ID: 1 1422550196).
2015-01-31 02:25:06 6762 6760 Completed cold level 0 restore ywdattbs06.
2015-01-31 02:27:32 6762 6760 Begin cold level 0 restore indextbs01 (Storage Manager
copy ID: 1 1422551385).
2015-01-31 02:29:12 6762 6760 Completed cold level 0 restore indextbs01.
2015-01-31 02:30:57 6762 6760 Begin cold level 0 restore logdbs (Storage Manager copy
ID: 1 1422552529).
2015-01-31 02:31:07 6762 6760 Completed cold level 0 restore logdbs.
2015-01-31 02:32:58 6762 6760 Begin cold level 0 restore phydbs (Storage Manager copy
ID: 1 1422552657).
2015-01-31 02:33:08 6762 6760 Completed cold level 0 restore phydbs.
2015-01-31 02:33:10 6762 6760 Completed whole system restore.
2015-01-31 02:33:10 6762 6760 /home/db/informix/bin/onbar_d complete, returning 0
(0x00)

恢復(fù)完成后
$ onstat -
Informix Dynamic Server Version -- Fast Recovery -- Up 01:26:21 -- 1816960 Kbytes
執(zhí)行onmode -m或者進(jìn)行必要的log回滾,例如onbar -r -l -t
$ onmode -m
$ onstat -
Informix Dynamic Server Version -- Fast Recovery (CKPT REQ) -- Up 01:27:27 -- 1816960 Kbytes
Blocked:CKPT
$ onstat -
Informix Dynamic Server Version -- On-Line -- Up 01:28:49 -- 1816960 Kbytes