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

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

How did “people you might know” find you on social software>>>

In the early morning, the program’s scheduled task was executed, and an error was reported: ora-00257: archiver error. Connect internal only, until free. Because of this problem, the timing task is wrong

Causes: ora-00257 error (insufficient space error) occurs. By searching for data, most of them say that it is caused by too many archived logs, which takes up all the remaining space of the hard disk. It can be solved by simply deleting logs or increasing storage space

Solution:

1. Secure CRT logs in to the server, switches users to Oracle, and connects to Oracle

[ root@userbeta ~]# su – oracle

[ oracle@userbeta ~]$ sqlplus /nolog

SQL> connect /as sysdba

2. Check the usage of flash recovery area. You can see that the archivelog is very large, reaching 99.94

SQL> select * from V$FLASH_ RECOVERY_ AREA_ USAGE;

3. Now let’s clean up the archivelog archive log. It is recommended to back up the production environment

Query log directory location

show parameter recover;