Oracle 10g Database "alter database open" Raises Errors ORA-16038 ORA-19809 ORA-00312

(Doc ID 1342214.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 10.2]
Information in this document applies to any platform.


An 'alter database open;' fails with errors as below:

$ strings spfiledb.ora

$ sqlplus "/ as sysdba"

SQL*Plus: Release - Production on Mon May 31 19:50:20 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options

SQL> startup mount
ORACLE instance started.

Total System Global Area 620756992 bytes
Fixed Size 780104 bytes
Variable Size 316938424 bytes
Database Buffers 301989888 bytes
Redo Buffers 1048576 bytes
Database mounted.

SQL> alter database open;
alter database open
ERROR at line 1:
ORA-16038: log 1 sequence# 230 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/oradata/10g/db/instant/redo01.log'



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms