Home » Server Options » Streams & AQ » how to successfully remove archivelog with oracle streams (10.2.0.2 Solaris 10)
how to successfully remove archivelog with oracle streams [message #335755] Wed, 23 July 2008 10:29 Go to next message
lhradowy
Messages: 5
Registered: June 2005
Location: Winnipeg, Canada
Junior Member
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.
Re: how to successfully remove archivelog with oracle streams [message #337033 is a reply to message #335755] Tue, 29 July 2008 13:13 Go to previous message
varunvir
Messages: 323
Registered: November 2007
Senior Member
SELECT * FROM v$archived_log
WHERE next_change# < (SELECT required_checkpoint_scn FROM dba_capture);
You can delete everything of this querry that it wont impact streams.
Previous Topic: Single instance of Callback procedures
Next Topic: archive log full! Using streams
Goto Forum:
  


Current Time: Sat Apr 19 03:09:06 CDT 2014

Total time taken to generate the page: 0.08951 seconds