Operating System - HP-UX
1748208 Members
2711 Online
108759 Solutions
New Discussion юеВ

ORA-00257: archiver error. Connect internal only Oracle streams.

 
SOLVED
Go to solution
Ratzie
Super Advisor

ORA-00257: archiver error. Connect internal only Oracle streams.

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.

3 REPLIES 3
Yogeeraj_1
Honored Contributor

Re: ORA-00257: archiver error. Connect internal only Oracle streams.

hi,

Do you have spare space on another file system?
(an nfs mounted drive would also do -- temporarily)

If yes, move the files there and link your archivelog directory to the new path.

after that: SQL> archive log start;


This should keep u going.

You should take remedial measure as from this.

hope this helps!
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Oviwan
Honored Contributor
Solution

Re: ORA-00257: archiver error. Connect internal only Oracle streams.

hey

move the oldest archivelogs to another disk. and then delete them in the rman repository:

login as oracle:
export ORACLE_SID=
rman target / nocatalog
crosscheck archivelog all;
delete noprompt expired archivelog all;

HTH
Regards oviwan

Ratzie
Super Advisor

Re: ORA-00257: archiver error. Connect internal only Oracle streams.

Sort of...
Moved files over to a larger slice.

alter system set log_archive_dest='';
alter system set DB_RECOVERY_FILE_DEST_SIZE = 20g scope = memory;
alter system set DB_RECOVERY_FILE_DEST='/dbbackups_odb/archive_temp/';


RMAN> CONNECT TARGET /
sql 'alter system archive log current';
RMAN> crosscheck archivelog all;
RMAN> catalog archivelog '/dbbackups_odb/archive_temp/1_106_658249860.dbf',
RMAN> backup archivelog all;
RMAN> allocate channel for maintenance type disk;

RMAN> change archivelog until time 'sysdate-7' delete;


Then changed everything back again.
I have some underlining questions about archives but will post another question regarding this.