Saturday, May 17, 2008

Limit exceeded for recovery files.

SQL> startup;
ORACLE instance started.

Total System Global Area 364904448 bytes
Fixed Size 778880 bytes
Variable Size 116137344 bytes
Database Buffers 247463936 bytes
Redo Buffers 524288 bytes
Database mounted.
ORA-16038: log 3 sequence# 693 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/u01/oradata/erprod/erprod/redo03.log'

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE = 10g;
...
SQL> shutdown immediate;
...
SQL> startup;

...no error message this time...

No comments: