在AIX433下恢复db2数据库错误！请帮忙

lyq管理

我使用下面命令恢复数据库
db2 restore db pl4db from /backup
显示信息如下：
"The system attempted to write to a read-only file.  SQLSTATE=55009"

我又用下面命令恢复数据库
db2 restore db pl4db from /backup redirect
显示信息如下：
SQL2539W  Warning!  Restoring to an existing database that is the same as the ba
ckup image database.  The database files will be deleted.
Do you want to continue ? (y/n) y
SQL1277N  Restore has detected that one or more table space containers are
inaccessible, or has set their state to 'storage must be defined'.
DB20000I  The RESTORE DATABASE command completed successfully.

请问是什么原因？有谁能帮助一下吗？

oh

REDIRECT - specifies a redirected restore operation. This command should be followed by one or more SET TABLESPACE CONTAINERS commands, and then by a RESTORE DATABASE command with the CONTINUE option.

楼主你的语法不太对哟

johndoe

同意楼上

我笨故我在new

原来数据库定义的容器使用的设备或者目录,你没有写权限.
db2 restore db pl4db from /backup redirect
重定向当然就没有问题了,这时候恢复还没真正开始,要定义了表空间的容器后恢复才能继续.