ORA-38784: Cannot create restore point ‘SNAPSHOT_STANDBY_REQUIRED_10/02/2021 18:42:36’.ORA-01153: an incompatible media recovery is active

Cause:

I try to convert physical standby to snapshot standby but got the error below

kish@STDBY>alter database convert to snapshot standby;
alter database convert to snapshot standby
*
ERROR at line 1:
ORA-38784: Cannot create restore point 'SNAPSHOT_STANDBY_REQUIRED_10/02/2021 18:42:36'.
ORA-01153: an incompatible media recovery is active

Workaround:

Cancel MRP first and perform the conversion

kish@STDBY>alter database recover managed standby database cancel;

Database altered.
kish@STDBY>alter database convert to snapshot standby;

Database altered.

Leave a Reply