使用命令:db2 backup db DB to /data/db2/ 提示一下错误
[db2inst1@localhost ~]$ db2 backup db JYDB online to /data/db2/ SQL2413N Online backup is not allowed because the database is not recoverable
原因分析:备份的文件目录没有权限
解决办法:进入到备份的目录的上一级(root)——然后
[root@localhost data]# ls db2 server v10.1fp4_linuxx64_server.tar.gz [root@localhost data]# pwd /data [root@localhost data]# cd /data/ [root@localhost data]# ls db2 server v10.1fp4_linuxx64_server.tar.gz [root@localhost data]# chmod 777 db2/ [root@localhost data]#
在使用命令备份即可
[db2inst1@localhost ~]$ db2 backup db DB to /data/db2/ Backup successful. The timestamp for this backup image is : 20180621115625 [db2inst1@localhost ~]$