Meral
作者Meral·2012-01-12 14:49
数据库管理员·GUOJI

database backup pending

字数 1820阅读 3038评论 0赞 0
数据库处于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

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

  • RMAN备份类型
    评论 0 · 赞 0
  • 什么是RAC集群
    评论 0 · 赞 0
  • oracle clusterware 命令(part1)
    评论 0 · 赞 0
  • RMAN删除备份的命令
    评论 0 · 赞 0
  • RMAN常用命令详解
    评论 0 · 赞 0
  • 相关文章

    相关问题

    相关资料

    X社区推广