暂无图片
DM8异常关闭,重新启动时报错-713,查询文档说是SEQ错误,求助如何修改SEQ.
我来答
分享
吃点吧,别累着
2021-10-11
DM8异常关闭,重新启动时报错-713,查询文档说是SEQ错误,求助如何修改SEQ.

报错如下:

2021-10-08 18:08:18.473 [ERROR] database P0000002168 T0000000000000016648 rlog_pkg_load_for_rafil E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-10-08_16-55-58.log failed, code=-713
2021-10-08 18:08:18.474 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-10-08_15-00-45.log ] for not consecutive.
2021-10-08 18:08:18.474 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-26_20-48-02.log ] for not consecutive.
2021-10-08 18:08:18.474 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-16_21-56-52.log ] for not consecutive.
2021-10-08 18:08:18.474 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-16_21-05-42.log ] for not consecutive.
2021-10-08 18:08:18.474 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-14_19-58-00.log ] for not consecutive.
2021-10-08 18:08:18.474 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-14_19-15-00.log ] for not consecutive.
2021-10-08 18:08:18.474 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-14_18-58-55.log ] for not consecutive.
2021-10-08 18:08:18.474 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-12_14-37-30.log ] for not consecutive.
2021-10-08 18:08:18.475 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-11_11-35-04.log ] for not consecutive.
2021-10-08 18:08:18.475 [WARNING] database P0000002168 T0000000000000016648 remove arch file [E:\dmdbms\data\DM1\ARCH\ARCHIVE_LOCAL1_0x1B3EE039[0]_2021-09-11_10-23-28.log ] for not consecutive.

我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
白青儿

单机还是集群环境?从日志看有归档不连续的异常,应该是有异常关闭情况,可以尝试做归档修复,使用语句repair archivelog database 'E:\dmdbms\data\DM1\dm.ini';做归档修复。

 SEQ是数据库自动维护的,和日志序列号LSN一样都是递增长的,由数据库自动维护,不建议修改。

如果是集群环境,可以尝试把备机重新利用主机的备份和归档文件恢复到最新状态。

暂无图片 评论
暂无图片 有用 0
Uncopyrightable

有备份用备份恢复,没有就咨询原厂服务吧,解决方案都没有怎么公开

暂无图片 评论
暂无图片 有用 0
吃点吧,别累着

就是单机,使用repair archivelog之后显示success,但是重新启动数据库的时候还是报同样错 。

暂无图片 评论
暂无图片 有用 0
白青儿

单机试试把归档关闭后启动数据库,如果能正常启动,再重新开启归档。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏