RMAN-08137: WARNING: archive log not deleted as it is still needed [message #427139] |
Wed, 21 October 2009 05:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
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 #427222 is a reply to message #427198] |
Wed, 21 October 2009 10:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Mahesh Rajendran wrote on Wed, 21 October 2009 18:19Are 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.
|
|
|
|
|
|
|
|