log shows below error and users are unable to connect to the database
First check in alert log
Following is error is
Errors in file \u01\oracle\product\11.2.0\diag\rdbms\TESTPROD\testprod\trace\test_arc1_1010.trc
ORA-16038: log 3 sequence# 1459 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '\u01\oracle\oradata\TESTPROD\redo03.LOG'
Cause of this message is because archive log file destination was changed or someone deleted/moved the archive log files manually using OS commands.
Use “DELETE EXPIRED ARCHIVELOG ALL” will alleviate the VALIDATION FAILED messages.
ARC1: Failed to archive thread 1 sequence 1459 (1809)
ARCH: Archival stopped, error occurred. Will continue retryi
How to resolve ORA-00257 errors
Solution:
1.first check the archive log file location
i ) SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive Destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 384
Next log sequence to archive 386
Current log sequence 386
ii ) show parameter db_recovery_file_dest;
2. If get location , then removed unwanted old files
check du -sch
remove unwanted file rm -rh <filename >
archive log file stored in FLASHBACK_RECOVERY_AREA
check the size of the
Also get the size of the db_recovery_file_dest
show parameter db_recovery_file_dest_size;
and also check the RMAN BACKUP details
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
If using flashback recovery area, then u can check the usage
SQL>show parameter db_recovery_file_dest_size;
db_recovery_file_dest_size=100G
SQL> alter system set db_recovery_file_dest_size=150G scope=both;
The issue has been resolved
No comments:
Post a Comment