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

Posted on October 2, 2021 by kishan1 Minute Read

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.

Published by kishan

Desire and obsessive to learn ! Generic technology enthusiast who have dynamic experience in database and other technologies. I have persistence to learn any niche skills faster. Served multiple DBA roles in fortune 500 companies to proactively prevent unexpected failure events. Inclined to take risks,face challenging situations and embrace fear! ***I would like to share my thoughts and ideas to this world !*** View all posts by kishan