ORA-16086: standby database does not contain available standby log files
edited May 2, 2012 5:31PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hi.
I got 2 databases on RAC and synched with data guard.
DB: 10.2.0.5
RHEL 5.3
The strange thing is that on my primary database, I'm able to send logs from node2 without any problems while node1 struggles with ORA-16086.
SQL> select status, error from v$archive_dest where dest_id=2;
STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-16086: standby database does not contain available standby
log files
1) Flash recovery area is good on the standby
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE .01 0 1
ONLINELOG 0 0 0
ARCHIVELOG .21 0 306
BACKUPPIECE .17 .16 19
IMAGECOPY .01 .01 1
FLASHBACKLOG 0 0 0
I got 2 databases on RAC and synched with data guard.
DB: 10.2.0.5
RHEL 5.3
The strange thing is that on my primary database, I'm able to send logs from node2 without any problems while node1 struggles with ORA-16086.
SQL> select status, error from v$archive_dest where dest_id=2;
STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-16086: standby database does not contain available standby
log files
1) Flash recovery area is good on the standby
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE .01 0 1
ONLINELOG 0 0 0
ARCHIVELOG .21 0 306
BACKUPPIECE .17 .16 19
IMAGECOPY .01 .01 1
FLASHBACKLOG 0 0 0
0