當做在線備份,即加上online參數后,可以看到如下告警:
[db2inst1@localhost backup]$ db2 backup db sample online to /dev/null
SQL2413N Online backup is not allowed because the database is not recoverable
or a backup pending condition is in effect.
很簡單,只要改成offline的默認備份方式即可:
[db2inst1@localhost backup]$ db2 backup db sample to /dev/null
Backup successful. The timestamp for this backup image is : 20131125221418
再次連接DB,就OK了:
[db2inst1@localhost backup]$ db2 connect to sample
Database Connection Information
Database server = DB2/LINUX 9.7.5
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
這時我們可以測試下日志歸檔是否成功:
[db2inst1@localhost backup]$ db2 terminate
DB20000I The TERMINATE command completed successfully.
[db2inst1@localhost backup]$ db2 archive log for db sample
DB20000I The ARCHIVE LOG command completed successfully.
再去LOGARCHMETH1設置的目錄下可以發現有如下路徑,日志成功歸檔:
[db2inst1@localhost C0000000]$ pwd
/db2src/TS/backup/db2inst1/SAMPLE/NODE0000/C0000000
[db2inst1@localhost C0000000]$ ls
S0000000.LOG
這樣就完成了日志歸檔到磁盤的設置工作,可以看到工作還是相當簡化的,只要配置了歸檔方式,重啟DB2后還需要做一個離線備份,即可完成DB2的歸檔配置,這樣DB2在被啟動手工歸檔或者日志空間不足的時候就會自動歸檔到這個目錄。