Skip to main content

Posts

Showing posts with the label ORA-00312

ORA-19809: limit exceeded for recovery files

The error was showing during startup. After searching I found a solution which worked. I thought you might like to know it. SQL> startup ORACLE instance started. Total System Global Area 2.5736E+10 bytes Fixed Size                  2165616 bytes Variable Size            2438657168 bytes Database Buffers         2.3287E+10 bytes Redo Buffers                8650752 bytes Database mounted. ORA-16038: log 3 sequence# 16828 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 3 thread 1: '/datafile/oracle/oradata/ULTIMUS/redo03.log' SQL> alter system set db_recovery_file_dest_size=150G; System altered. SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 2.5736E+10 bytes F...