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.
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:
