Oracle Error ORA-38799: Cannot drop guaranteed restore point internally created for snapshot standby

Oracle Error Message

ORA-38799: Cannot drop guaranteed restore point internally created for snapshot standby

Reason for the Error

An attempt is made to drop the guaranteed restore point Oracle created internally for a snapshot standby.

Solution

Use the “alter database convert to physical standby” command to convert the snapshot standby to a normal physical standby. This will automatically flashback the database and drop this guaranteed restore point.