informix ontape

/***********************************************************************/
informix ontape
/***********************************************************************/
1 参数onconfig 文件
#  cd $INFORMIXDIR/etc
# more onconfig.gbaseserver 
TAPEDEV /dev/null
TAPEBLK 32
TAPESIZE 0
LTAPEDEV /dev/null
LTAPEBLK 32
LTAPESIZE 0
BACKUP_FILTER
RESTORE_FILTER


# vi onconfig.gbaseserver 
TAPEDEV /home/informix/backup/tapedev
LTAPEDEV /home/informix/backup/ltapedev
 
注： 一旦设置了LTAPEDEV 就要 定期备份日志。否则程序会因日志的 问题而挂住。


2 备份到目录
ontape -s -L 0


3 从目录恢复
[informix@node1 tapedev]$ ontape -r


Physical restore failed - Cannot warm restore ROOT DBspace 


[informix@node1 tapedev]$ onmode -ky 


[informix@node1 tapedev]$ ontape -r


Continue restore? (y/n)y
Do you want to back up the logs? (y/n)y
File created: /home/informix/backup/ltapedev/node1_0_Log0000001537
Log salvage is complete, continuing restore of archive.
Restore a level 1 archive (y/n) n
Do you want to restore log tapes? (y/n)n
/home/informix/gbase/bin/onmode -sy


Program over.


4 改为多用户模式
[informix@node1 tapedev]$ onmode -m


5 当前数据库的 模式
[informix@node1 tapedev]$ onstat -




6 关闭数据库
[informix@node1 tapedev]$ onmode -ky


7 启动数据库 
[informix@node1 tapedev]$ oninit -vy


8  ontape -p 后数据库 不能启动


[informix@node1 tapedev]$ onstat -m
shared memory not initialized for INFORMIXSERVER 'gbaseserver'


Message Log File: /home/informix/gbase/tmp/online.log
17:17:22  B-tree scanner index compression level set to med.
17:17:22  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
  in DBSPACETEMP: 'tmpdbs1'
17:17:22  Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
  in DBSPACETEMP: 'tmpdbs2'
17:17:22  Physical Recovery Started at Page (1:756474).
17:17:22  Physical Recovery Complete: 41 Pages Examined, 35 Pages Restored.
17:17:22  Logical Recovery Started.
17:17:22  10 recovery worker threads will be started.
17:17:22  Fast Recovery Switching to Log 1538
17:17:22  Fast Recovery Switching to Log 1539
17:17:23  Logical Recovery has reached the transaction cleanup phase.
17:17:23  Logical Recovery Complete.
 1573 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks


17:17:23  oninit: Fatal error in shared memory initialization


17:17:23  GBase 8t Database Server Stopped.


17:17:23  mt_shm_remove: WARNING: may not have removed all/correct segments




 
9  备份日志


[informix@node1 ~]$ ontape -a


Performing automatic backup of logical logs.


File created: /home/informix/backup/ltapedev/node1_0_Log0000001538
File created: /home/informix/backup/ltapedev/node1_0_Log0000001539
File created: /home/informix/backup/ltapedev/node1_0_Log0000001540
File created: /home/informix/backup/ltapedev/node1_0_Log0000001541
File created: /home/informix/backup/ltapedev/node1_0_Log0000001542
File created: /home/informix/backup/ltapedev/node1_0_Log0000001543
File created: /home/informix/backup/ltapedev/node1_0_Log0000001544
File created: /home/informix/backup/ltapedev/node1_0_Log0000001545
File created: /home/informix/backup/ltapedev/node1_0_Log0000001546
File created: /home/informix/backup/ltapedev/node1_0_Log0000001547
Do you want to back up the current logical log? (y/n) y
File created: /home/informix/backup/ltapedev/node1_0_Log0000001548


Program over.
 


10 启动日志自动备份
10.1 # vi onconfig.gbaseserver 
ALARMPROGRAM $INFORMIXDIR/etc/alarmprogram.sh


10.2 #$INFORMIXDIR/etc/alarmprogram.sh
BACKUPLOGS=Y
BACKUP_CMD="ontape -a -d"


10.3 修改alarmprogram.sh 的 #!/bin/ksh 为 #!/bin/sh 
[informix@node1 etc]$ vi alarmprogram.sh
#!/bin/sh


11 恢复到其他机器
1)需要的文件 oncfg_$INFORMIXSERVER.SERVERNUM
如：oncfg_gbaseserver.0 


2) 如果引用了额外的SO 文件，需要将该文件 放到合适的目录


3) 备份文件名是用和该主机的名称命名的，所以 恢复到其他机器上要将该备份文件名称改为 该主机的名称。


4) touch 表空间文件
cd /opt/dbs
touch datadbs1 datadbs2 datadbs3 datadbs4 llogdbs llogdbs2 plogdbs rootdbs sbspace tmpdbs1 tmpdbs2
chmod 660 *


5) 恢复文件 (ontape 只能恢复 ontape 备份的 文件)
ontape -r