数据库处于backup pending state的时候,除了备份DB以外,还可以使用db2dart工具来使数据库脱离此状态。 d000ha@haha:/dbhome/d000ha$db2 update db cfg using LOGARCHMETH1 DISK:/dblogs/archive/ DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.SQL1363W One or more of the parameters submitted for immediate modification were not changed dynamically. For these configuration parameters, all applications must disconnect from this database before the changes become effective. d000ha@haha:/dbhome/d000ha$db2 terminate DB20000I The TERMINATE command completed successfully. d000ha@haha:/dbhome/d000ha$db2 get db cfg for sample|grep LOGARCHMETH1 First log archive method (LOGARCHMETH1) = DISK:/dblogs/archive/ d000ha@haha:/dbhome/d000ha$db2 connect to sample SQL1116N A connection to or activation of database "SAMPLE" cannot be made because of BACKUP PENDING. SQLSTATE=57019 d000ha@haha:/dbhome/d000ha$db2dart sample /CHST Please enter What state, and setting for it: (DBBP - Database backup pending; OFF or ON) dbbp off Updated the log file header control file. The requested DB2DART processing has completed successfully! Complete DB2DART report found in: /dbhome/d000ha/sqllib/db2dump/DART0000/SAMPLE.RPT d000ha@haha:/dbhome/d000ha$db2 connect to sample Database Connection Information Database server = DB2/AIX64 9.5.6 SQL authorization ID = d000ha Local database alias = SAMPLE
添加新评论0 条评论