Tag Archives: Error correction

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

The following error occurred recently while operating an Oracle database:

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

The main reason for this error is that there are too many archived logs, which leads to insufficient disk space. It can be solved by deleting logs or increasing space. The specific operation is as follows :(this error is solved by deleting logs here)
1. First log in to Oracle at the terminal using the following command

sqlplus /nolog
connect /as sysdba

2. Execute the following statement and check the use of Flash Recovery Area. Archivelog is already very large, close to 100.

select * from V$FLASH_RECOVERY_AREA_USAGE;

3. Use the following command to query the storage directory of Archivelog and backup it if necessary.

show parameter recover;

4. Delete the log files in the corresponding directory
5. After the log document is deleted, the control file must be maintained using RMAN, otherwise the space will still not be released. The terminal enters RMAN maintenance with the following command:

rman target sys/pass

Check for useless Archivelog:

crosscheck archivelog all;

Delete all Archivelog as of the previous day:

delete archivelog until time 'sysdate-1';

6. Query the use of Flash Recovery Area again, and you will find that a lot of space is released. At this point, the error has been resolved