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.
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.
0 comments:
Post a Comment