Shulou(Shulou.com)06/01 Report--

Description: host1 server as onbar backup test, host2 server as onbar recovery test.

1. Configure backup parameters

Onmode-wf BAR_BSALIB_PATH=/home/informix/lib/libbsapsm.so

Onmode-wf ALARMPROGRAM=/home/informix/etc/log_full.sh

Onmode-wf LTAPEDEV=/home/informix/backup/LOGPOOL

2. Define the PSM backup directory

Onpsm-D add / home/informix/backup/DBSPOOL-g DBSPOOL-p HIGHEST-t FILE

Onpsm-D add / home/informix/backup/LOGPOOL-g LOGPOOL-p HIGHEST-t FILE

3. View backup directory information

Onpsm-D list

4. Delete the backup directory at the LOW level and keep the directory at the HIGHEST level just defined.

Onpsm-D del / home/informix/backups-d-g DBSPOOL-y

Onpsm-D del / home/informix/backups-d-g LOGPOOL-y

5. Perform database level 0 backup through onbar

Onbar-b-L 0

Onpsm-C export

6. Transfer backup files from host1 to host2

Scp gbaseserver.tar informix@192.168.1.21:/home/informix/backup/DBSPOOL/

Scp psm_catalog.tar informix@192.168.1.21:/home/informix/backup/DBSPOOL/

Scp ixbar.1 informix@192.168.1.21:/home/informix/gbase/etc/

7. Host2 environment variable sets the time format

Export GL_DATETIME= "Y-%m-%d H:%M:%S"

8. Restore by point in time in host2

Cd / home/informix/backup/DBSPOOL/

Onpsm-C init

Onpsm-C import

Onbar-r-t "2016-07-14 12:16:56"

9. After the recovery is completed, the database enters quiescent mode and needs to switch to online mode

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.