注册

DM7日志恢复失败

DM_788757 2021/01/07 1062 6

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM7
【操作系统】:RedHat6.5
【CPU】:
【问题描述】*:查询日志备份集的db_magic为负数导致恢复语句语法不通过,以下是执行的语句

  1. /opt/xfyb-dameng-linux-4.1.2/bin/job_logs/database/DmServiceDMSERVER/recovery/DmServiceDMSERVER_FULL_BAK_11_mapped_file.txt
  2. /opt/dmdbms/bin/dmrman CTLSTMT=“RESTORE DATABASE ‘/opt/dmdbms/data/DAMENG/dm.ini’ FROM BACKUPSET ‘/nfs/246/11/DmServiceDMSERVER_FULL_BAK_11’ MAPPED FILE ‘/opt/xfyb-dameng-linux-4.1.2/bin/job_logs/database/DmServiceDMSERVER/recovery/DmServiceDMSERVER_FULL_BAK_11_mapped_file.txt’”
  3. /opt/dmdbms/bin/dmrman CTLSTMT=“RESTORE ARCHIVELOG FROM BACKUPSET ‘/nfs/246/11/DmServiceDMSERVER_AUTO_LOG_BAK_11_1’ ALL TO ARCHIVEDIR ‘/opt/dmdbms/data/DAMENG/arch’”
  4. /opt/dmdbms/bin/dmrman CTLSTMT=“RESTORE ARCHIVELOG FROM BACKUPSET ‘/nfs/246/11/DmServiceDMSERVER_AUTO_LOG_BAK_11_2’ ALL TO ARCHIVEDIR ‘/opt/dmdbms/data/DAMENG/arch’”
  5. 查询/nfs/246/11/DmServiceDMSERVER_AUTO_LOG_BAK_11_2的DB_MAGIC为-78086660
  6. [/opt/dmdbms/bin/dmrman CTLSTMT=“RECOVER DATABASE ‘/opt/dmdbms/data/DAMENG/dm.ini’ WITH ARCHIVEDIR ‘/opt/dmdbms/data/DAMENG/arch’ USE DB_MAGIC -78086660 UNTIL TIME ‘2021-01-07 13:08:41’”

执行前5步都是成功的,执行到最后一步报错

回答 0
暂无回答
扫一扫
联系客服