Hi,
As I have suggested to check the progress of the dataguard use the following query
SQL> select status,error from v$archived_dest where dest_id = (dest-id of log_archive_dest_integer );
STATUS ERROR
———————————————————————————
VALID
And to put the physical standby in recovery mode use the following query.
SQL> alter database recover managed standby database disconnect from session;
However when u use the following query
SQL> recover managed standby database disconnect from session;
to put the standby in recovery mode u can sometimes get following error
From primary
SQL> SQL> select status,error from v$archived_dest where dest_id = (dest-id of log_archive_dest_integer );
STATUS ERROR
———————————————————————————————
Ora-1010 invalid oci operation
OR
STATUS ERROR
———————————————————————————————
ora-12152 TNS send break message
Hence to avoid such error always use the following query to put the physical standby in recovery mode
SQL> alter database recover managed standby database disconnect from session;
