Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

V$ARCHIVED_LOG how to clean

873970Apr 6 2018 — edited Apr 13 2018

Hi, all

I have created standby database and when i check redo apply process all is going well , but when i query V$ARCHIVED_LOG

i saw that some old archive logs shown here as a not applied.

I want to clean information about old archivelogs from V$ARCHIVED_LOG view.

İ have set control_file_record_keep_time=0  but there is no effect.

How can I clean V$ARCHIVED_LOG immediately?

I tried:

RMAN> crosscheck archivelog all;

RMAN> delete archivelog all;

RMAN> delete expired archivelog all;

There is not effect to the V$ARCHIVED_LOG view

Thanks.

This post has been answered by Mark D Powell on Apr 8 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2018
Added on Apr 6 2018
14 comments
2,530 views