Home » Server Options » Data Guard » RMAN-08137: WARNING: archive log not deleted as it is still needed (Oracle 10.2.0.4(x86_64), RHEL5.3(x86_64))
RMAN-08137: WARNING: archive log not deleted as it is still needed [message #427139] Wed, 21 October 2009 05:32 Go to next message
ursusca
Messages: 30
Registered: September 2009
Member

Hello,

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>';




After that I checked my standby database

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
    -------------- ---------- ---
             13335         1 NO
             13335         2 NO
             13082         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.
Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #427152 is a reply to message #427139] Wed, 21 October 2009 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
I can't help you but this is a nice, complete and clear post and question we seldomly see.
Thanks for it.

Regards
Michel

[Updated on: Wed, 21 October 2009 06:02]

Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #427198 is a reply to message #427139] Wed, 21 October 2009 09:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 9793
Registered: March 2002
Location: oracleDocoVille
Senior Member
Are you also using streams?
>>I noticed about every log that was being backed up was accompanied by a warning

There are other bugs associated with this (something to do with delete input option).
Check metalink.

[Updated on: Wed, 21 October 2009 09:20]

Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #427219 is a reply to message #427152] Wed, 21 October 2009 10:11 Go to previous messageGo to next message
ursusca
Messages: 30
Registered: September 2009
Member

Michel Cadot wrote on Wed, 21 October 2009 15:02
I can't help you but this is a nice, complete and clear post and question we seldomly see.
Thanks for it.

Regards
Michel

Hello Michel

Thank you anyway.
Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #427222 is a reply to message #427198] Wed, 21 October 2009 10:15 Go to previous messageGo to next message
ursusca
Messages: 30
Registered: September 2009
Member

Mahesh Rajendran wrote on Wed, 21 October 2009 18:19
Are you also using streams?
>>I noticed about every log that was being backed up was accompanied by a warning

There are other bugs associated with this (something to do with delete input option).
Check metalink.


Hello Mahesh Rajendran

Thank you for attention to my problem. I've read DOC ID 602960.1 on Metalink. I am not using streams. I use "DELETE ALL INPUT" in my RMAN script that's why I see these messages.
Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #427223 is a reply to message #427222] Wed, 21 October 2009 10:19 Go to previous message
Mahesh Rajendran
Messages: 9793
Registered: March 2002
Location: oracleDocoVille
Senior Member
Look into Doc# 373066.1
It is close.
Previous Topic:October CPU Patch
Next Topic:Where is the broker log location?
Goto Forum:
  


Current Time: Tue Dec 1 17:42:25 CST 2009

Total time taken to generate the page: 0.02815 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.