Share |

ORA-00257: Archiver error. Connect internal only, until freed

Your database is running in ARCHIVELOG mode: 
SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG
Because the database is running in archive log mode, the redo log files are archived to an archive destination.

(one of) the destination(s) have no sufficient space left to write the archived redo logs to. 

SQL> select destination from v$archive_dest;
...
Check if there is sufficient space left, if not, archive the archived redo logs to tape/other disk/...

The database should free itself after this error. If this is not the case try issuing the alter system archive log all; command connected AS SYSDBA.
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-00257 Add your own message



reply On 20-AUG-2008 09:31:21 Vinita asked: ORA_00257: archiver error
Reply
I have installed ORACLE 10g on HP-UX. I have two databases on the server, both having their db_recovery_file_dest in flash_recovery_area. Eventually, I got this archiver error. I deleted the archive log from its destination, i.e. from flash_recovery_area, but still problem was not solved. Then I deleted archive logs from the second database also. For the first time it worked, but then again when I faced the same problem, it didn't worked. Please provide some help as soon as possible.

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: 6m2ci3jbk8knuwa4k


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.