Sponsored Links
ORA-19809: limit exceeded for recovery files
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 6 08:53:07 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3355443200 bytes
Fixed Size 2024464 bytes
Variable Size 922749936 bytes
Database Buffers 2415919104 bytes
Redo Buffers 14749696 bytes
Database mounted.
ORA-16038: log 6 sequence# 20433 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 6 thread 1:
`/u01/app/oracle/oradata/redo07.log`
ORA-00312: online log 6 thread 1:
`/u01/app/oracle/oradata/redo071.log`
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
Solution
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 1000G;
System altered.
SQL> shutdown immediate;
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 3355443200 bytes
Fixed Size 2024464 bytes
Variable Size 922749936 bytes
Database Buffers 2415919104 bytes
Redo Buffers 14749696 bytes
Database mounted.
Database opened.
SQL>
Page 1
|
| 
