用duplicate創建完成physical standby之後,在standby上使用alter database recover managed standby database disconnect from session正準備同步日誌時,主庫與備庫的alert日誌中均出現以下:
primary
----------------------------------------------------
FAL[server]: Fail to queue the whole FAL gap
standby
-----------------------------------------------------
FAL[client]: Failed to request gap sequence
FAL[client]: All defined FAL servers have been attempted.
根據以上的錯誤提示,初步判斷為出現了gap,那就看看究竟是哪裡斷了日誌而產生的gap。但是在主庫與備庫上均提示未出現gap,結果如下:
select * from v$archive_gap;
no rows selected