db2备份/恢复常用命令

发布时间 2023-11-17 09:20:23作者: julian_chang

首先要切换到数据库用户中

su - db2inst1

1.连接数据库

db2 connect to databaseName

2.创建数据库

db2 create db databaseName using codeset utf-8 territory CN

3.断开连接

db2 force applications all

4.导入数据库

db2 restore db databaseName taken at 20231109031212 replace existing

5.再次登录时报错使用

db2 rollforward db easysite to end of logs and stop

db2 rollforward db ttsite to end of logs and complete

如果缺少日志文件,从源数据库中把相应的日志拷贝过来放到日志目录中,再次执行一次

6.查看数据库配置(日志文件目录)

db2 get db cfg for databaseName

7.备份命令

db2 backup database databaseName online to /home/db2inst1/tmp/

db2 backup database databaseName online to /home/db2inst1/tmp/  include logs