数据库备份sehll

1.备份程序
#!/usr/bin/csh

source /opt/informix/.cshrc

cd /opt/informix/tnms_sc_backup/databack

mkdir tnms_sc

cd tnms_sc

dbschema -d tnms_sc -ss tnms_sc.sql>/opt/informix/tnms_sc_backup/databack/backup.log

dbaccess -e tnms_sc /opt/informix/tnms_sc_backup/create_unload.sql>>/opt/informix/tnms_sc_backup/databack/backup.log

dbaccess -e tnms_sc /opt/informix/tnms_sc_backup/create_load.sql>>/opt/informix/tnms_sc_backup/databack/backup.log

dbaccess -e tnms_sc /opt/informix/tnms_sc_backup/databack/tnms_sc/unload.sql

cd /opt/informix/tnms_sc_backup/databack

cp backup.log ./tnms_sc

set time_stamp=`date "+%y%m%d%H%M"`

tar -cvf tnms_sc$time_stamp.tar tnms_sc

/usr/bin/gzip tnms_sc$time_stamp.tar

rm -rf ./tnms_sc
2.恢复过程
gunzip *.gz
tar -xvf *.tar
cd database_bak_dir
dbaccess -e tnms_sc080325 tnms_sc.sql
dbaccess -e tnms_sc080325 load.sql