- 论坛徽章:
- 0
|
我用restore恢复数据库:
$ db2 restore db cisfedb from /db2_backup taken at 20070617020002
SQL2523W Warning! Restoring to an existing database that is different from the database on the backup image, but have matching names. The target database will be overwritten by the backup version. The Roll-forward recovery logs associate
d with the target database will be deleted.
Do you want to continue ? (y/n) y
SQL0294N The container is already in use. SQLSTATE=42730
这个时候我连接数据库db2 connect to cisfedb
SQL1119N A connection to or activation of database "CISFEDB" cannot be made because a previous restore is incomplete. SQLSTATE=57019
用db2 get db cfg for cisfedb 看一下数据库的状态。
看参数 Rollforward pending =YES
Restore pending =Database
请教如何恢复数据库,本人刚开始学习,请大家说得详细点,谢谢了! |
|