Thursday, June 21, 2012
Home » Unlabelled » ORA-19809: limit exceeded for recovery files
Hasan B
1:25 PM
0 comments

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
Fixed Size                  2165616 bytes
Variable Size            2438657168 bytes
Database Buffers         2.3287E+10 bytes
Redo Buffers                8650752 bytes
Database mounted.
Database opened.
Posted by Hasan B at 1:25 PM
Share:

0 comments:

Post a Comment

:) :)) ;(( :-) =)) ;( ;-( :d :-d @-) :p :o :>) (o) [-( :-? (p) :-s (m) 8-) :-t :-b b-( :-# =p~ $-) (b) (f) x-) (k) (h) (c) cheer
Click to see the code!
To insert emoticon you must added at least one space before the code.