Oracle standby database recovery stopped

oraclerecoverystandby

I have a primary and an standby database.
Because my file-system became full in standby database, the recovery has stopped in standby.

This is the present state of sequences in primary and standby:

Thread Last Sequence Received Last Sequence Applied Difference

     1                    560                   394        166

How can I start the recovery again?

Best Answer

You then have the option of either starting a managed recovery operation or opening the database for read-only access.

Start the database:

SQL> STARTUP NOMOUNT;

Mount the standby database:

SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

Start the managed recovery operation:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE 
  2> DISCONNECT FROM SESSION;