Solved it myself meanwhile by doing this :
- shutdown standby
- startup nomount
- alter database mount standby database
- recover standby database until cancel
AUTO
Then it started to run through the archlogs and applying them. Also had
a corrupted archlog as well (fixed that). But at the end, after I
thought it finised running through all archlogs, it seemed that Oracle
stopped applying them. Could see that in V$ARCHIVE_DEST_STATUS.
Then stopped database and started again in managed recovery and issue
"alter system switch logfile" on primary and bingo.
Everything seems fine now. Standby is not behind any more.
Received on Thu Apr 20 2006 - 08:27:29 CDT
