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;