25M报错如下：
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.
单机还是集群环境？从日志看有归档不连续的异常，应该是有异常关闭情况，可以尝试做归档修复，使用语句repair archivelog database 'E:\dmdbms\data\DM1\dm.ini';做归档修复。
SEQ是数据库自动维护的，和日志序列号LSN一样都是递增长的，由数据库自动维护，不建议修改。
如果是集群环境，可以尝试把备机重新利用主机的备份和归档文件恢复到最新状态。
评论
有用 0