2023-08-02 11:56:01.249 [ERROR] database P0000001370 T0000000000000002815 rafil_list_overlap_consecutive_check failed, rfil(/dm8/data/arch/ARCHIVE_LOCAL1_0x343DAFF7_EP0_2023-07-26_17-40-45.log)->next_seq(10145), next rfil(/dm8/data/arch/ARCHIVE_LOCAL1_0x343DAFF7_EP0_2023-08-02_09-42-49.log)->arch_seq(10245)
2023-08-02 11:56:01.249 [ERROR] database P0000001370 T0000000000000002815 rarch_sync_process, rafil_collect_by_dsc_seqno failed, code=-718
2023-08-02 11:56:01.249 [ERROR] database P0000001370 T0000000000000002815 rarch_local_arch_send, rarch_sync_process failed, code:-718!
2023-08-02 11:56:01.249 [INFO] database P0000001370 T0000000000000002815 rarch_local_arch_send to HAN02 finished, code=-718, dseq=1690940595, max_arch_lsn=0!
请问:此时只能重建备份搭建备库么? 主库的归档都在,我手工将归档拷贝过去行么?
code:-718,是因为归档不连续。搭建主库环境时可以先做一个检查点 checkpoint(100),再做备份,可以有效避免这个报错。
目前可以重新搭建,也可以尝试dmrman里repair。
1、关库。
2、./dmrman
3、RMAN> repair archivelog database '/.../.../.../dm.ini';