Oracle ORA-00257 error Solution

Rchive log is full
ORA-00257: How to Handle archiver error. Connect internal only, until freed error
 
1. Log On with the sys user
Sqlplus sys/pass @ tt as sysdba
 
2. Check the location of the archiv log.
SQL> show parameter log_archive_dest;
NAME TYPE VALUE
-----------------------------------------------------------------------------
Log_archive_dest string
Log_archive_dest_1 string
Log_archive_dest_10 string
 
3. If the VALUE is null, you can use archive log list to check the archive directory and log sequence.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 360
Next log sequence to archive 360
Current log sequence 362
4. Check the usage of the flash recovery area. We can see that archivelog is already large, reaching 96.62.
SQL> select * from V $ FLASH_RECOVERY_AREA_USAGE;
 
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
----------------------------------------------------------------------
CONTROLFILE. 13 0 1
ONLINELOG 2.93 0 3
ARCHIVELOG 96.62 0 141
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
 
5. Calculate the space occupied by the flash recovery area
SQL> select sum (percent_space_used) * 3/100 from v $ flash_recovery_area_usage;
 
SUM (PERCENT_SPACE_USED) * 3/100
-----------------------------
2.9904
 
6. Find the recovery directory, show parameter recover
SQL> show parameter recover;
NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_recovery_file_dest string/u01/app/Oracle/flash_recovery_area
Db_recovery_file_dest_size big integer 5G
Recovery_parallelism integer 0

1 2 3 Next Page