ORA-19809 ORA-19804
I trying to open a one of our old database and I am getting following error
SQL> startup
ORACLE instance started.
Total System Global Area 5117050880 bytes
Fixed Size 8757424 bytes
Variable Size 1207963472 bytes
Database Buffers 3892314112 bytes
Redo Buffers 8015872 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7328
Session ID: 373 Serial number: 9392
Alert log file :
Errors in file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_ora_1280.trc:
ORA-16038: log 3 sequence# 63 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: ‘C:\APP\ORACLE\ORADATA\AUDITDB\ONLINELOG\O1_MF_3_G3XO7R8J_.LOG’
ORA-00312: online log 3 thread 1: ‘C:\APP\ORACLE\FAST_RECOVERY_AREA\AUDITDB\AUDITDB\ONLINELOG\O1_MF_3_G3XO7YNR_.LOG’
2019-06-12T12:06:43.111652+03:00
USER (ospid: 1280): terminating the instance due to error 16038
ERROR: Unable to normalize symbol name for the following short stack (at offset 125):
dbgeGetAsyncActivForED()+939<-dbkif_record_dde_actions()+421<-ksuitm_opt()+2482<-ksuitm()+14<-kcfopd()+10758<-adbdrv_options..0()+38247<-adbdrv()+161<-opiexe()+29912<-opiosq0()+6886<-kpooprx()+464<-kpoal8()+1173<-opiodr()+1378<-ttcpip()+1368<-opitsk()+2474<-opiino()+1265<-opiodr()+1378<-opidrv()+1833<-sou2o()+112<-opimai_real()+499<-opimai()+231<-OracleThreadStart()+745<-00007FFDB0B084D4<-00007FFDB340E851
2019-06-12T12:06:43.181682+03:00
Errors in file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_tt00_12308.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 209715200 bytes disk space from 10009706496 bytes limit
2019-06-12T12:06:43.489757+03:00
System state dump requested by (instance=1, osid=1280), summary=[abnormal instance termination].
System State dumped to trace file C:\APP\ORACLE\diag\rdbms\auditdb\auditdb\trace\auditdb_diag_13476_20190612120643.trc
2019-06-12T12:06:47.049651+03:00
Instance terminated by USER, pid = 1280
Solution :
Deleted the old archivelog file and reclaim space
SQL> startup mount
ORACLE instance started.
Total System Global Area 5117050880 bytes
Fixed Size 8757424 bytes
Variable Size 1207963472 bytes
Database Buffers 3892314112 bytes
Redo Buffers 8015872 bytes
Database mounted.
RMAN> crosscheck archivelog all; or delete archivelog all
RMAN> delete expired archivelog all;
SQL> alter database open;
Database altered.
SQL> select status from v$instance;
STATUS
————
OPEN