Re: delete obsolete for archivelogs

  • From: Jay Hostetter <hostetter.jay@xxxxxxxxx>
  • To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 8 Jul 2010 15:45:32 -0400

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.

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: