Getting ORA-19809: limit exceeded for recovery files

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.
Start the database
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:
‘F:ORACLEPRODUCT10.2.0ORADATAORCLREDO02.LOG’
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 2G
Solution: Increase the value of db_recovery_file_dest_size following way.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G;
System altered.
Now open the database.
SQL> alter database open;
Database altered.
  • January 11, 2017 | 17 views
  • Comments