Oracle Standby Datbase Manual Recovery

This article explain how to recover standby database manually..
You can execute these command while running production database and no effect to live system.It will effect only if the DR server is configures to High Availability Mode.

Login to sqlplus in DR site as sysdba

SQL > alter database recover managed standby database cancel;

Then it will cancel the current standby database process and archive log shipping

SQl > recover standby database;

TYPE AUTO and enter

Check the out put if some archive logs are missing .
If it not manual recovery is successful.

Then make the standby database as it is.

SQL> alter database recover managed standby database disconnect from session;

Do these tasks periodically and ensure your DR server is uptodate