Re: delete obsolete for archivelogs

I finally have this issue resolved.  Oracle Streams had been setup for this
database, but was disabled.  Therefore, Oracle apparently thought it needed
to keep the archivelogs around.  I ran the following command as SYS:

exec dbms_streams_adm.remove_streams_configuration() ;

"report obsolete" now lists the archivelogs that have been backed twice.

Thank you for all of the responses.
Jay

On Wed, Jun 30, 2010 at 3:16 PM, Jay Hostetter <hostetter.jay@xxxxxxxxx>wrote:

> Ravi - I am getting both of these types of messages:
>
> skipping archived log file
> H:\ORACLE\ORADATA\SALES2\ARCHIVE\ARC23830_0686767139.001; already backed up
> 2 time(s)
>
> input archived log thread=1 sequence=23831 RECID=23774 STAMP=722817180
> Tony - Thank you for the sympathies!  Yes, the backups succeed.  No errors
> in the alert log or event viewer.
> Interesting thought regarding the  virus checker, etc. But I can force rman
> to delete the files - just not with "delete noprompt obsolete".
>
> I think you folks have helped me to rule out that it isn't anything
> obvious. I'll post the solution, when I get one from Oracle Support.
>
> Thank you,
> Jay
>
>

Other related posts: