Hi All,
Currently I'm facing a issue with my Logical Standby database. Primary and Logical standby Database is not in Sync. The Gap is around 10. But all the archives are shipped to Logical Standby Database from Primary and registered in it.
When I checked in the alertlog of Logical Standby Database, I found the below:
"LOGMINER: Alternate logfile found. Transition to mining archived logfile for session 1 thread 1 sequence 7912, "<Archive location>"
The archives are there in the Logical Standby Database.
The Database version is 11.2.0.4 and Jan CPU 2015 is also applied on it.
Please find the current status below and help me on this.
Logical Standby Status:
current status:
------------------------------------------------------------------------------------------ --------
|
| /export/backups/standby/archives_log2/1_7908_824738398.dbf | YES |
| /export/backups/standby/archives_log2/1_7909_824738398.dbf | YES |
| /export/backups/standby/archives_log2/1_7910_824738398.dbf | YES |
| /export/backups/standby/archives_log2/1_7911_824738398.dbf | YES |
| /export/backups/standby/archives_log2/1_7912_824738398.dbf | CURRENT |
| /export/backups/standby/archives_log2/1_7913_824738398.dbf | NO |
| /export/backups/standby/archives_log2/1_7914_824738398.dbf | NO |
| /export/backups/standby/archives_log2/1_7915_824738398.dbf | NO |
| /export/backups/standby/archives_log2/1_7916_824738398.dbf | NO |
| /export/backups/standby/archives_log2/1_7917_824738398.dbf | NO |
| /export/backups/standby/archives_log2/1_7918_824738398.dbf | NO |
| /export/backups/standby/archives_log2/1_7919_824738398.dbf | NO |
| /export/backups/standby/archives_log2/1_7920_824738398.dbf | NO |
| /export/backups/standby/archives_log2/1_7921_824738398.dbf | NO |