Oracle standby database recovery stopped 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?
You then have the option of either starting a managed recovery operation or opening the database for read-only access.

Start the database:

SQL&gt; STARTUP NOMOUNT;


Mount the standby database:

SQL&gt; ALTER DATABASE MOUNT STANDBY DATABASE;


Start the managed recovery operation:

SQL&gt; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE 
  2&gt; DISCONNECT FROM SESSION;