Shulou(Shulou.com)06/01 Report--

ORA-00257: archiver error. Connect internal only, until freed.Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.Action: Check the archiver trace file for a detailed description of the problem. Also, verify that the device specified in the initialization parameter archive_log_dest is set up properly for archiving.

Roughly speaking, oracle failed to save redo file. Let the login database check to see if there is a problem with archive_log_dest.

First go to the database to check whether or not

SQL > select * from v$flash_recovery_area_usage

You can see that one value of PERCENT_SPACE_USED is 99.7 and its corresponding FILE_TYPE is ARCHIVELOG. So you can roughly know that the ARCHIVELOG is full!

Select sum (percent_space_used) * 3 from v$flash_recovery_area_usage 100 from v$flash_recovery_area_usage can see how much space archivelog takes up, while show parameter recover can know how much archivelog space is allocated by the system.

Then exit the database, enter rman, and prepare to delete archivelog

Ramn target /

Perform delete operation

RMAN > delete archivelog all

After the deletion is complete, the access connection appears normal here

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.