Solve oracle archiving logs full (ORA-00257)

Solve ORA-00257: archiver error. Connect internal only, until freed this issue is due to archiving logs full. Solution: SQL> select * from V $ FLASH_RECOVERY_AREA_USAGE; FILE_TYPE commandid NUMBER_OF_FILES ------------ commandid --------------- CONTROLFILE 0 0 0 ONLINELOG 0 0 0 0 ARCHIVELOG 99.9 0 255 BACKUPPIECE 0 0 0 IMAGECOPY 0 0 0 FLASHBACKLOG 0 0 0 0 note, the number of ARCHIVELOG logs reaches 99.9%. Delete it! SQL> quitC: \ Documents ents and Settings \ Administrator> rmanRMAN> connect target system/myoracle @ orcl Note: system is an oracle user, and myoracle is the oracle user password, orcl is the name SID of the connected database. RMAN> crosscheck archivelog all; RMAN> delete expired archivelog all; Note: delete expired archives so that the archive files are deleted. Go to sqlplus to view the ARCHIVELOG log usage! The second method is to increase the maximum size of the flash log file. As shown in the following figure: alter system set DB_RECOVERY_FILE_DEST_SIZE = 10g or more. The processing method is when an error occurs when the log is full. We recommend that you perform a task to regularly Delete the log, as shown below: delete archivelog all completed before 'sysdate-7'; // DELETE the archive delete archivelog from time 'sysdate-7' seven days ago