Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

archive logs & oracle streams

Ratzie
Super Advisor

archive logs & oracle streams

Oracle 10.2.0.2 and oracle streams.
I backed up the archive logs, but only deleted anything older then 7 days.

I ran the command:
SELECT name FROM v$archived_log
WHERE next_change# < (SELECT first_scn FROM dba_capture);

Which should identify the archive logs that streams no longer needs. Which is fine.

I then deleted these logs as above, which had all the files older then 7 days listed in the select command.
RMAN> change archivelog until time 'sysdate-7' delete;

So can someone explain when I run:
SELECT * FROM v$archived_log
WHERE next_change# < (SELECT first_scn FROM dba_capture);

It returns all the archive logs, but the name is now BLANK! With ARCHIVED =YES and DELETED = YES, with a status of D.

And when I run:
SELECT name FROM dba_logmnr_log ORDER BY first_scn;

It shows the exact files that my first command stated I did not need?!

So, how do I, or can I purge the v$archive_log to clean this mess up.