现象： After upgrading database to 19c where flashback is enabled and when a ...

刘泽宇

现象：
Flashback performed on primary and opened with resetlogs and then Flashback database to SCN failing with ORA-16016 on standby database


ORA-00283: recovery session canceled due to errors
ORA-38861: flashback recovery stopped before reaching recovery target
ORA-16016: archived log for thread 1 sequence# 54238 unavailable

原因：
archivelog sequence#54238 has been backedup from standby and deleted from archive destination and this archivelog doesnt exists on primary as well

处理方法：
Restore archivelog from backup and then rerun the flashback database