René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Switching a physical standby database to read only and vice versa

From standby to read only

alter database recover managed standby database cancel;
alter database open read only;

From read only to standby

alter database recover managed standby database disconnect from session;