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.