Thursday, November 22, 2012

dropping restore point on db with active data guard



in order to be able go back in case of a big issue with application releases, i always create 
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 :

received :

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 .




No comments: