on all db's a guaranteed restore point … both the normal physical standby database as the active data guard database.
typically i drop those after a couple of days
i wanted to do the same thing on the active data guard db
however it didn't let me do :
SQL> drop restore point before9; drop restore point before9 *ERROR at line 1:ORA-16000: database open for read-only access
stopping the media recovery didn't help either same error. :
i will need to stop the database and mount it in order to delete the restore point .