This content has been marked as final. Show 3 replies
There was a bug but not your version :
V$Archived_log "Applied" column not updated For Downstream Capture [ID 602960.1]
It looks more like this Oracle Note :
RMAN deleting archive log(s) but file remains on disk [ID 1105372.1]
If that does not work I would try to manually applied it.
well, the log IS applied but according to the reference manual it's applied in memory and its changes has not been yet applied to the datafiles.
what i see is that the changes remains in memory until a log switch occurs. then the status for applied changes to YES and the new log gets the "IN-MEMORY" status...
So what I would do is this :
On the Primary :
alter system set log_archive_dest_state_2=defer;
Then stop recovery on the Standby and shutdown the database.
Startup mount and start recovery again and run you query again on that sequence.
If it finally clears enable the primary again.
alter system set log_archive_dest_state_2=enable;
If not try to register it yourself.
By chance does this show its waiting for a gap
select process, status, sequence#, block# from v$managed_standby;
Edited by: mseberg on Aug 23, 2011 8:38 AM