Got the error when starting an Oracle database:
SQL> startup
ORACLE instance started.
Total System Global Area 1010827264 bytes
Fixed Size 2045480 bytes
Variable Size 385878488 bytes
Database Buffers 603979776 bytes
Redo Buffers 18923520 bytes
Database mounted.
ORA-16038: log 3 sequence# 42 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/u02/oradata/DB/redo03.log'
SQL> startup
ORACLE instance started.
Total System Global Area 1010827264 bytes
Fixed Size 2045480 bytes
Variable Size 385878488 bytes
Database Buffers 603979776 bytes
Redo Buffers 18923520 bytes
Database mounted.
ORA-16038: log 3 sequence# 42 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/u02/oradata/DB/redo03.log'
Solution:
To solve ORA-19809 error, increase the value of db_recovery_file_dest_size parameter. And start the database:
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=3G SCOPE=BOTH;
SQL> shutdown abort
SQL> startup
No comments:
Post a Comment