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: 40
Registered: September 2009
Location: Toronto, ON
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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]

Report message to a moderator

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: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
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]

Report message to a moderator

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: 40
Registered: September 2009
Location: Toronto, ON
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: 40
Registered: September 2009
Location: Toronto, ON
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 messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look into Doc# 373066.1
It is close.
Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #441594 is a reply to message #427139] Tue, 02 February 2010 01:28 Go to previous messageGo to next message
1raju2
Messages: 3
Registered: February 2010
Junior Member
Hi ursusca,

Iam seeing the same issue.please tell me how did you fix this.
Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #441613 is a reply to message #441594] Tue, 02 February 2010 03:27 Go to previous messageGo to next message
ursusca
Messages: 40
Registered: September 2009
Location: Toronto, ON
Member

1raju2 wrote on Tue, 02 February 2010 10:28
Hi ursusca,

Iam seeing the same issue.please tell me how did you fix this.


Hello,

I had the possibility to restart my primary DB and my problem was gone.
Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #441733 is a reply to message #441613] Tue, 02 February 2010 23:14 Go to previous messageGo to next message
1raju2
Messages: 3
Registered: February 2010
Junior Member
i dont have the flexibility to bounce the db. is there any other solution.
Re: RMAN-08137: WARNING: archive log not deleted as it is still needed [message #442129 is a reply to message #427139] Thu, 04 February 2010 21:53 Go to previous message
1raju2
Messages: 3
Registered: February 2010
Junior Member
killing the archiving process resolved the issue.
Previous Topic: How To Switch Oracle Primary And Standby (what was I doing wrong!!)
Next Topic: DATA GURAD IMPLENTATION
Goto Forum:
  


Current Time: Thu Mar 28 12:41:19 CDT 2024