重庆思庄Oracle、Redhat认证学习论坛
标题:
Alter database convert to physical standby Fails ORA-38770 ORA-19899
[打印本页]
作者:
刘泽宇
时间:
2023-12-31 13:03
标题:
Alter database convert to physical standby Fails ORA-38770 ORA-19899
现象:
SQL> alter database convert to physical standby;
alter database convert to physical standby
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-38770: FLASHBACK DATABASE failed during recovery.
ORA-19899: missing incarnation information
Flashback Restore skipped because target SCN <scn> is in future.
Flashback Media Recovery Start
Started logmerger process
Recovery Slave PR00 previously exited with exception 38770
Flashback Media Recovery failed with error 10879
ORA-283 signalled during: alter database convert to physical standby...
2022-02-09T11:02:22.321323+05:30
ALTER SYSTEM SET _no_recovery_through_resetlogs=FALSE SCOPE=BOTH;
2022-02-09T11:04:29.040953+05:30
alter database convert to physical standby
2022-02-09T11:04:29.042432+05:30
ALTER DATABASE CONVERT TO PHYSICAL STANDBY (<name>)
2022-02-09T11:04:29.517566+05:30
Flashback Restore skipped because target SCN <SCN> is in future
改变:
Following Parameter was set in Standby
_allow_resetlogs_corruption= TRUE
This is an Unsupported parameter and doesnot check datafile header consistency and opens the database.
This parameter was set and database converted to Snapshot database.
This introduces the issue.
When the Database is converted back to Physical standby it considers the SCN of Flashback as Future SCN
Flashback Restore skipped because target SCN <SCN> is in future
原因:
_allow_resetlogs_corruption= TRUE was used
处理方法:
Unset the parameter _allow_resetlogs_corruption
Rebuild the Standby database using fresh backup of Primary
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)
Powered by Discuz! X3.2