重庆思庄Oracle、Redhat认证学习论坛

标题: 现象: After upgrading database to 19c where flashback is enabled and when a ... [打印本页]

作者: 刘泽宇    时间: 2024-7-28 15:17
标题: 现象: 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






欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2