DB2 pureScale在线备份与恢复
查看DB2 pureScale集群实例信息，我的DB2 pureScale环境包含2个CF和2个MEMBER
[db2inst1@member1 ~]$ db2instance -list
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
-- ---- ----- --------- ------------ ----- ---------------- ------------ -------
0 MEMBER STARTED member1 member1 NO 0 0 member1
1 MEMBER STARTED member2 member2 NO 0 0 member2
128 CF PRIMARY cf1 cf1 NO - 0 cf1
129 CF PEER cf2 cf2 NO - 0 cf2
HOSTNAME STATE INSTANCE_STOPPED ALERT
-------- ----- ---------------- -----
cf2 ACTIVE NO NO
cf1 ACTIVE NO NO
member2 ACTIVE NO NO
member1 ACTIVE NO NO
DB2 pureScale开启归档模式+离线备份，在member1节点操作
创建归档路径
[db2inst1@member1 ~]$ mkdir arch_log
配置归档目录
[db2inst1@member1 ~]$ db2 update db cfg for db01 using LOGARCHMETH1 "disk:/home/db2inst1/arch_log"
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
此时不能正常连接数据库，需要先做一次离线备份
[db2inst1@member1 ~]$ db2 connect to db01
SQL1116N A connection to or activation of database "DB01" failed because the
database is in BACKUP PENDING state. SQLSTATE=57019
离线备份数据库DB01
[db2inst1@member1 ~]$ db2 backup database db01
Backup successful. The timestamp for this backup image is : 20220918232329
创建1条测试数据
[db2inst1@member1 ~]$ db2 connect to db01
Database Connection Information
Database server = DB2/LINUXX8664 10.5.10
SQL authorization ID = DB2INST1
Local database alias = DB01
[db2inst1@member1 ~]$ db2 "create table t1(id int not null,name varchar(99),primary key(id))"
DB20000I The SQL command completed successfully.
[db2inst1@member1 ~]$ db2 "insert into t1 values(1,'name1')"
DB20000I The SQL command completed successfully.
在线备份数据库，此时备份中只包含1条数据
[db2inst1@member1 ~]$ db2 backup database db01 online
Backup successful. The timestamp for this backup image is : 20220918232518
在1条插入测试数据
[db2inst1@member1 ~]$ db2 "insert into t1 values(2,'name2')"
DB20000I The SQL command completed successfully.
此时测试表中共有2条数据
[db2inst1@member1 ~]$ db2 "select count(*) as ROW_COUNT from t1"
ROW_COUNT
-----------
2
利用在线备份进行恢复+日志前滚
[db2inst1@member1 ~]$ db2 restore database db01 from /home/db2inst1/
SQL2539W The specified name of the backup image to restore is the same as the
name of the target database. Restoring to an existing database that is the
same as the backup image database will cause the current database to be
overwritten by the backup version.
Do you want to continue ? (y/n) y
DB20000I The RESTORE DATABASE command completed successfully.
[db2inst1@member1 ~]$ db2 "rollforward database db01 to end of logs and complete"
Rollforward Status
Input database alias = db01
Number of members have returned status = 2
Member ID Rollforward Next log Log files processed Last committed transaction
status to be read
----------- -------------------------- ------------------- ------------------------- --------------------------
0 not pending S0000000.LOG-S0000001.LOG 2022-09-19-03.27.45.000000 UTC
1 not pending S0000000.LOG-S0000000.LOG 2022-09-19-03.33.17.000000 UTC
DB20000I The ROLLFORWARD command completed successfully.
再次查看测试表中的数据
[db2inst1@member1 ~]$ db2 "select count(*) as ROW_COUNT from t1"
ROW_COUNT
-----------
2
1 record(s) selected.
DB2 pureScale架构的数据库备份与单机备份无区别。
