Cancel/Stop Managed Standby Recovery

While connected to the standby database follow following steps:

• ALTER DATABASE SET STANDBY DATABASE UNPROTECTED;
• RECOVER MANAGED STANDBY DATABASE CANCEL;
• ALTER DATABASE OPEN READ ONLY;

The database can subsequently be switched back to recovery mode as follows:

Start-up managed recovery on standby database

• CONNECT / AS SYSDBA
• SHUTDOWN IMMEDIATE
• STARTUP NOMOUNT
• ALTER DATABASE MOUNT STANDBY DATABASE;
• RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;