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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s