我在数据库HELLO中有一个表EMPLOYEE.EMPLOYEE,其中包含3条记录,如下所示:
EMP_NO BIRTH_DATE FIRST_NAME LAST_NAME GENDER HIRE_DATE BANK_ACCOUNT_NUMBER PHONE_NUMBER
------- ---------- ------------------ -------------------- ------ ---------- ------------------- --------------
1. 06/05/1998 A B M 01/02/2019 026201521420 +91X
2. 10/14/1997 C D M 01/07/2019 034212323454 +91Y
3. 05/27/1997 E F F 01/14/2019 92329323123 +91Z 然后,我首先使用以下命令进行脱机备份
mkdir offlinebackup
db2 terminate
db2 deactivate database HELLO
db2 backup database HELLO to ~/offlinebackup/在此之后,我得到以下输出:
Backup successful. The timestamp for this backup image is : 20190128115210现在,我使用以下命令进行在线备份
db2 update database configuration for HELLO using LOGARCHMETH1 'DISK:/database/config/db2inst1/onlinebackup'
db2 backup database HELLO online to /database/config/db2inst1/onlinebackup compress include logs在此之后,我将得到如下输出:
Backup successful. The timestamp for this backup image is : 20190128115616现在我返回到db2并运行CONNECT TO HELLO,它将我连接到我的数据库。当我检查EMPLOYEE.EMPLOYEE表中的行时,我仍然得到了所有的3行。
现在我用EMP_NO 3删除行,成功地删除了这一行。然后,我从db2终端运行quit
然后,我使用以下命令从脱机备份运行还原:
db2 restore db HELLO from ~/offlinebackup/ replace existing上面写着DB20000I The RESTORE DATABASE command completed successfully
现在我尝试连接到HELLO,它显示为SQL1117N A connection to or activation of database "HELLO" cannot be made because of ROLL-FORWARD PENDING. SQLSTATE=57019
我对它运行db2 rollforward db HELLO to end of logs and stop
然后我连接到HELLO并尝试找出行,我只得到了2行,而不是备份中的3行。
EMP_NO BIRTH_DATE FIRST_NAME LAST_NAME GENDER HIRE_DATE BANK_ACCOUNT_NUMBER PHONE_NUMBER
------- ---------- ------------------ --------------------- ------ ---------- ------------------- --------------
1. 06/05/1998 A B M 01/02/2019 026201521420 +91X
2. 10/14/1997 C D M 01/07/2019 034212323454 +91Y第三条记录不可见,它存在于备份中。有人知道为什么我不能从备份中恢复第三条记录吗
发布于 2019-01-28 21:54:38
您运行的前滚命令:
db2 rollforward db HELLO to end of logs and stop已重放所有可用日志,包括与delete语句对应的记录。
如果您希望在备份完成后立即将数据库恢复到该状态,则可以运行
db2 rollforward db HELLO to end of backup and stop或者,由于您是从脱机备份恢复,因此完全不需要前滚,您可以使用
db2 rollforward db HELLO stop或者,完全跳过前滚(当然,仅用于脱机备份):
db2 restore db HELLO from ~/offlinebackup/ replace existing without rolling forwardhttps://stackoverflow.com/questions/54401748
复制相似问题