Informix进行0级备份并恢复

备份

使用ontape工具进行备份，在使用前我们要找到onconfig修改部分参数，可以在环境变量中找到ONCONFIG的配置，这里我们配置的是onconfig.tramsserver

首先创建备份目录

[informix@informix ~]$ mkdir -p /informix/informix/backup
[informix@informix ~]$ mkdir -p /informix/informix/backup/dbbackup
[informix@informix ~]$ mkdir -p /informix/informix/backup/logbackup

然后进入$INFORMIXDIR，再进入etc，打开onconfig.tramsserver

[informix@informix etc]$ cd $INFORMIXDIR
[informix@informix informix]$ cd etc
[informix@informix etc]$ vi onconfig.tramsserver

修改参数，将TAPEDEV修改为DB目录、LTAPEDEV修改为LOG目录

执行命令

[informix@primary etc]$ ontape -s -L 0
10 percent done.
100 percent done.
File created: /opt/informix/backup/dbbackup/primary_0_L0

Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:

 3

Program over.

恢复

先停机

[informix@primary etc]$ onmode -ky

使用ontape进行恢复，需要注意备份文件在onconfig.tramsserver配置的路径中

[informix@primary etc]$ ontape -r
Restore will use level 0 archive file /opt/informix/backup/dbbackup/primary_0_L0. Press Return to continue ...


Archive Tape Information

Tape type:      Archive Backup Tape
Online version: IBM Informix Dynamic Server Version 11.70.FC8IE
Archive date:   Mon Mar 31 16:59:16 2025
User id:        informix
Terminal id:    /dev/pts/1
Archive level:  0
Tape device:    /opt/informix/backup/dbbackup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1

Spaces to restore:1 [rootdbs                                                                                                                         ]

Archive Information

IBM Informix Dynamic Server Copyright 2001, 2013  IBM Corporation.
Initialization Time       03/31/2025 15:55:54
System Page Size          2048
Version                   26
Index Page Logging        OFF
Archive CheckPoint Time   03/31/2025 16:59:16

Dbspaces
number   flags    fchunk   nchunks  flags    owner                            name
1        40001    1        1        N  BA    informix                         rootdbs                                                                           


Chunks
chk/dbs offset   size     free     bpages   flags pathname
1   1   0        100000   37221             PO-B- /opt/informix/data/rootdbs

Continue restore? (y/n)y
Do you want to back up the logs? (y/n)y
File created: /opt/informix/backup/logbackup/primary_0_Log0000000001
File created: /opt/informix/backup/logbackup/primary_0_Log0000000002
File created: /opt/informix/backup/logbackup/primary_0_Log0000000003
Log salvage is complete, continuing restore of archive.
Restore a level 1 archive (y/n) y
Ready for level 1 tape
Restore will use level 1 archive file /opt/informix/backup/dbbackup/primary_0_L1. Press Return to continue ...

File /opt/informix/backup/dbbackup/primary_0_L1 not found, continuing ...
Do you want to restore log tapes? (y/n)y

Roll forward should start with log number 3
Restore will use log backup file /opt/informix/backup/logbackup/primary_0_Log0000000003. Press Return to continue ...

Rollforward log file /opt/informix/backup/logbackup/primary_0_Log0000000003 ...

Program over.