ORA-00257:archiver error

Question

When I try connecting to my database, I get the following error.

ORA-00257:archiver error. Connect internal only until freed.

Till yesterday, the database was pretty functional.

Any workaround?

Given

possible duplicate of RA-00257: archiver error. Connect internal only, until freed. – Hexaemeron

@Hexaemeron - Most likely, the source of the problem is different in 9i and 10g. As a result, I believe they ought to be considered separate questions. – Oidea

@Justin: I doubt it. It's a pretty common Oracle error, the cause is usually the same - it's run out of log space. Either way, it's a DBA problem, not a programming one. – Hexaemeron

Answer 1

In SQL*Plus, can you

SQL> show parameter log_archive

• If LOG_ARCHIVE_START is FALSE, you'll want to set it to TRUE.
• If LOG_ARCHIVE_DEST points to an invalid directory, you'll want to change it to point to a valid directory.

Oidea

I get no output when I run show parameter log_archive. I have a read-only permission to the db. Is that the reason why I get no output? – Given

You'll need to be a DBA in order to fix the error. If you just have a read-only account, you'll need to contact the DBA. – Oidea

Thanks Justin! I will contact the DBA for this. – Given

Answer 2

ORA-00257:archiver error is occured when your archivelog reached the FRA limit. So you have to clear the archivelogs or you may increase the FRA limit.

To clear the archivelogs, connect to the command prompt and follow steps below:

rman target /
RMAN> delete archivelog all;

It will ask for confirmation and you have to give 'yes'.

Whish

At first, It can solve the problem immediately! But ... you are putting your DB into dangerous situation (have gap in archivelog). :( – Gouge

Answer 3

please note that you can only access SQL*PLUS if you login as sqlplus / as sysdba

Plus, I think the problem here is space quota for archiving reaching its max limit.

So its best to clear the logs after making backup on a flash or something

Asthenopia

Answer 4

ORA-00257: archiver error. Connect internal only, until freed. problem can be solved as following: copy archivelog folder to a new destination and empty this directory.

The real problem is that online-backup limit increased what was set as n GB and that become full when you empty this archivelog folder then it will start working fine

Laryngology

Answer 5

I have encountered this error couple of times, it simply tells that archivelog space has exhausted and need to be freed.

run cmd as administrator

> set oracled_sid=write_oracle_sid_here
> rman target sys/put_sys_password_here
> crosscheck archivelog all;
> delete noprompt expired archivelog all;
>exit;

Na

Answer 6

Open rman or cmd, then type: connect target sys/live; press enter then: delete archivelog all; press enter

Ask for confirmation press y then enter. Your issue will be solved.

Orlene