Home » Server Options » Streams & AQ » archive log full! Using streams (10.2.0.2)
archive log full! Using streams [message #335527] Tue, 22 July 2008 08:06 Go to next message
lhradowy
Messages: 5
Registered: June 2005
Location: Winnipeg, Canada
Junior Member
Subject: ORA-00257: archiver error. Connect internal only

So, I have not run a backup in about two weeks.
With Oracle GUI (OEM) saves my life since I am not a dba.
Now, I have filled up my archive logs drive slice. It is at 100%.
We are running Oracle streams, and I can not automatically delete backed up archive logs after a backup because streams may still be using it.
So how do I fix the problem!!!
Oracle 10.2.0.2

So can I delete the archive logs... Well, no, because if I remove them from the OS, Oracle will still think they are there or should be there...
OK command line mode, RMAN backup, yikes, not at that level yet.
Then how to remove the archive logs...

Question:
I read a document on streams...
How to identify redo logs that streams no longer needs:
SELECT name
FROM v$archived_log
WHERE next_change# < (SELECT first_scn FROM dba_capture);

Does this mean these can be deleted?

Identify redo logs that Streams has purged:
SELECT file_name
FROM dba_logmnr_purged_log;
Again, does this mean these can be deleted?
The numbers are not the same.
Re: archive log full! Using streams [message #337032 is a reply to message #335527] Tue, 29 July 2008 13:08 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
select required_checkpoint_scn from dba_capture.Then you can delete all archivelogs having scn below that number.
Re: archive log full! Using streams [message #337673 is a reply to message #335527] Thu, 31 July 2008 10:34 Go to previous message
sriramkalyan
Messages: 7
Registered: November 2007
Location: Silver spring MD, USA
Junior Member


Displaying the Log Files That Will Never Be Needed by Any Capture Process
SELECT * FROM DBA_LOGMNR_PURGED_LOG;



Previous Topic: how to successfully remove archivelog with oracle streams
Next Topic: Stream script
Goto Forum:
  


Current Time: Thu Mar 28 15:13:01 CDT 2024