一、 循环日志下的版本恢复

zhuhichn

一、 循环日志下的版本恢复

概要:(图例略)
最简单最基本的一个例子 - 循环日志下的离线备份和恢复。

要点:
做了动作后，别忘了做检查来验证动作的正确性。
认真、细心是DBA最基本的素质。很多时候能救命的并不是多高级的技术。

问题:
问题1: 实际上这里还故意遗漏一些在生产环境中必须要做的重要步骤，那是？
问题2: 这一过程的操作流程图？

操作过程:
1.注册
login(user: db2inst1)

2.连接
db2 connect to sample

3.查看备份数据库设定 & 确认日志模式
db2 get db cfg > /mnt/hgfs/F/backup/database.cfg.bak
db2 terminate
LOGARCHMETH1=OFF
LOGARCHMETH2=OFF
LOGRETAIN=OFF
USEREXIT=OFF

4.全备份
CMD:    
db2 backup database sample to /mnt/hgfs/F/backup/
RESULT:
Backup successful. The timestamp for this backup image is : 20100505160724

5.检查备份镜像文件
CMD:    db2ckbkp -h /mnt/hgfs/F/backup/SAMPLE.0.db2inst1.NODE0000.CATN0000.20100505160724.001
RESULT:
=====================
MEDIA HEADER REACHED:
=====================
        Server Database Name           -- SAMPLE
        Server Database Alias          -- SAMPLE
        Client Database Alias          -- SAMPLE
        Timestamp                      -- 20100505160724
        Database Partition Number      -- 0
        Instance                       -- db2inst1
        Sequence Number                -- 1
        Release ID                     -- D00
        Database Seed                  -- BED6FFF2
        DB Comment's Codepage (Volume) -- 0
        DB Comment (Volume)            --
        DB Comment's Codepage (System) -- 0
        DB Comment (System)            --
        Authentication Value           -- -1
        Backup Mode                    -- 0
        Includes Logs                  -- 0
        Compression                    -- 0
        Backup Type                    -- 0
        Backup Gran.                   -- 0
        Status Flags                   -- 1
        System Cats inc                -- 1
        Catalog Partition Number       -- 0
        DB Codeset                     -- UTF-8
        DB Territory                   --
        LogID                          -- 1272190778
        LogPath                        -- /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLOGDIR/
        Backup Buffer Size             -- 4460544
        Number of Sessions             -- 1
        Platform                       -- 1E

 The proper image file name would be:
SAMPLE.0.db2inst1.NODE0000.CATN0000.20100505160724.001


[1] Buffers processed:  ###################################

Image Verification Complete - successful.

6。查看恢复历史记录
CMD:
db2 list history all for sample
RESULT: 部分
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20100505160724001   F    D  S0000000.LOG S0000000.LOG  
 ----------------------------------------------------------------------------
  Contains 5 tablespace(s):

  00001 SYSCATSPACE                                                           
  00002 USERSPACE1                                                            
  00003 IBMDB2SAMPLEREL                                                       
  00004 IBMDB2SAMPLEXML                                                       
  00005 SYSTOOLSPACE                                                          
 ----------------------------------------------------------------------------
    Comment: DB2 BACKUP SAMPLE OFFLINE                                        
 Start Time: 20100505160724
   End Time: 20100505160735
     Status: A
 ----------------------------------------------------------------------------
  EID: 5 Location: /mnt/hgfs/F/backup

7.误删除 障碍!
 删除前的备份 db2 "export to file01.del of del select * from act" ==>18 rows
 删除数据 db2 "delete from act"
 确认 db2 "select count(*) from act" ==>0 row

8.恢复和结果确认
CMD: db2 restore database sample from /mnt/hgfs/F/backup/
RESULT:  DB20000I  The RESTORE DATABASE command completed successfully.
确认
db2 "export to file01.del of del select * from act"
diff file01.del file02.del
恢复历史记录
CMD:     db2 list history all for sample
RESULT:  部分
 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
 -- --- ------------------ ---- --- ------------ ------------ --------------
  R  D  20100505171611001   F       S0000000.LOG S0000000.LOG 20100505160724
 ----------------------------------------------------------------------------
  Contains 5 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
  00003 IBMDB2SAMPLEREL
  00004 IBMDB2SAMPLEXML
  00005 SYSTOOLSPACE
 ----------------------------------------------------------------------------
    Comment: RESTORE SAMPLE NO RF
 Start Time: 20100505171611
   End Time: 20100505171639
     Status: A