¡¾ÇóÖú¡¿»Ö¸´DB2Êý¾Ý¿âºó£¬ÎÞ·¨Á¬½ÓÉÏÊý¾Ý¿â£¬Ôõô°ì£¬ËÓа취
´ÓÔÚÏßϵͳµ¼ÁËÒ»¸öDB2Êý¾Ý¿âÎļþ£¬»Ö¸´µ½×Ô¼ºµÄϵͳÀïÃæºó£¬ÔÙconnect£¬Ò»Ö±Á¬½Ó²»ÉÏ£¬¶øÇÒÕû¸ö»úÆ÷ºÃÏñ¶¼²»ÏìÓ¦ÁË£¬²»ÖªµÀÊÇÔõô»ØÊÂÇé¡£ÊDz»Êǻָ´Á˱ðµÄ»·¾³µÄÊý¾Ý¿âºó£¬ÒªÐÞ¸ÄʲôÅäÖòÎÊý²ÅÄÜÁ¬½ÓÉÏÈ¥¡£
ÄÄλ¸ßÈËÄÜÖ¸µãһϡ£ Ê×ÏÈ¿´Äã»Ö¸´µÄÊÇÍêÕû±¸·Ý»¹ÊÇÔöÁ¿±¸·Ý£¡
ÍêÕû±¸·ÝµÄ»Ö¸´£º
1¡¢Restore db [DBName] from [DBPath] Taken AT [Time]
2¡¢Êý¾Ý¿âϵͳÖÐûÓжÔÏóÊý¾Ý¿â»¹ÒªÔÚÉÏÃæµÄÃüÁîºóÃæ¼ÓÉÏ TO [target-path] INTO [NewDBName]
3¡¢½«¸Ãʱ¼ä¶ÎµÄÊý¾Ý¿âLOGÎĸ´ÖƵ½ÐµÄÊý¾Ý¿â¶ÔÓ¦µÄλÖÃ
4¡¢Rollforward db [DBName] TO END OF LOGS AND STOP
×¢:DB2 v8.1»¹´æÔÚÓÐÎÊÌ⣬Èç¹ûÖ´ÐеÚ4²½µÄʱºòûÓгɹ¦£¬ÇåÖØÐ´ӵÚÒ»²½¿ªÊ¼Ö´ÐÐ
ÔöÁ¿±¸·ÝµÄ»Ö¸´£º
1¡¢Restore db [DBName] from [DBPath] Taken AT [Time] ×¢£º»Ö¸´×÷ΪÔöÁ¿±¸·ÝµÄ»ù´¡ÍêÕû±¸·Ý
2¡¢Êý¾Ý¿âϵͳÖÐûÓжÔÏóÊý¾Ý¿â»¹ÒªÔÚÉÏÃæµÄÃüÁîºóÃæ¼ÓÉÏ TO [target-path] INTO [NewDBName]
3¡¢Restore db [DBName] Incremental from [DBPath] Taken AT [Time] ×¢£ºÈç¹ûûÓÐʹÓÃDeltaÔöÁ¿±¸·ÝÖ±½Ó»Ö¸´×îºóÒ»´ÎµÄÔöÁ¿Êý¾Ý¿âµÄ±¸·ÝÎļþ£¬Èç¹ûʹÓÃÇ밲ʱ¼äÒÀ´Î»Ö¸´Êý¾Ý¿âµÄ±¸·ÝÎļþ
4¡¢½«¸Ã×îеļä¶ÎµÄÊý¾Ý¿âLOGÎĸ´ÖƵ½ÐµÄÊý¾Ý¿â¶ÔÓ¦µÄλÖÃ
5¡¢Rollforward db [DBName] TO END OF LOGS AND STOP
×¢£ºÔöÁ¿»Ö¸´µÄʱºòÓÈÆäÈÝÒ׳öÏÖ´íÎó£¬Èç¹ûÔÚµÚ5²½Ê±Ìáʾ´íÎó£¬ÇëÖ´ÐÐRollforward db [DBName] STOP£¬È»ºóÁ¬½Ó¡£Èç¹ûÁ¬½Ó²»³É¹¦£¬ÇëÖØ¸´ÒÔÉϲ½Ö裡
Ò³:
[1]