Oracle Database Discussions

HI ALL,

I faced with gaps on my standby database. I copyed all of the identified missing archived redo log files to the
target standby database manually and registered them.


SQL> ALTER DATABASE REGISTER PHYSICAL LOGFILE '<filename>'

SQL> select thread#, low_sequence#, high_sequence# from v$archive_gap;
now rows selected





The output of the


select sequence#,
archived,
applied,
to_char(completion_time, 'YYYY.MM.DD HH24:MI') as completed
from v$archived_log


statement shows that all archived redo logs were applied.

But on primary database RMAN doesn't delete archived log files. When I looked at my RMAN message log, I noticed about every log that was being backed up was accompanied by a warning:
RMAN-08137: WARNING: archive log not deleted as it is still needed
I checked primary database:



SQL> select max (SEQUENCE#),DEST_ID,APPLIED from v$archived_log group by DEST_ID,APPLIED ;

MAX(SEQUENCE#) DEST_ID APP
-------------- ---------- ---
1193 1 NO
1193 2 NO
1160 2 YES



I've read here http://marist89.blogspot.com/2008/04/rman-08137-warning-archive-log-not.html about a bug (bug 4538727). It's a bug that was supposedly fixed in 10.2.0.4, but that's mine version.

How can I solve this problem? Any response will be very much appreciate. Thanks in advance.