ORA-19809: limit exceeded for recovery files


oracle@bakuexa1dbadm01:~$ sqlplus "/ as sysdba";
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 18 10:32:46 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select * from tab;
select * from tab
 *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
Shutdown the database first
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 1250356 bytes
Variable Size 180358092 bytes
Database Buffers 411041792 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-16038: log 2 sequence# 135 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1:
Problem: The value db_recovery_file_dest_size is not enough for generate archive log
SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE;
NAME TYPE VALUE
------------------------------------ ----------- -------------------
db_recovery_file_dest_size big integer 20G
Solution: Increase the value of db_recovery_file_dest_size following way.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 40G;
System altered.
Now open the database.
SQL> alter database open;
Database altered.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: