Skip to content
Advertisements

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

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: