为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM7
【操作系统】:RedHat6.5
【CPU】:
【问题描述】*:查询日志备份集的db_magic为负数导致恢复语句语法不通过,以下是执行的语句
- /opt/xfyb-dameng-linux-4.1.2/bin/job_logs/database/DmServiceDMSERVER/recovery/DmServiceDMSERVER_FULL_BAK_11_mapped_file.txt
- /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’”
- /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’”
- /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’”
- 查询/nfs/246/11/DmServiceDMSERVER_AUTO_LOG_BAK_11_2的DB_MAGIC为-78086660
- [/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步都是成功的,执行到最后一步报错
没人?还是这问题没人会吗