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