group: CDOS: Oracle: need help with ORA-19809: limit exceeded for recovery files

From: <owensmith99_at_gmail.com>
Date: Sat, 01 Sep 2007 23:21:57 -0000
Message-ID: <1188688917.513075.125950@19g2000hsx.googlegroups.com>

Oracle DBAs,

I am seeing this when I try to startup:

bash sol oracle ~ 2 $ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 1 17:17:41 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 268435456 bytes

Fixed Size                  1279672 bytes
Variable Size             171968840 bytes
Database Buffers           88080384 bytes
Redo Buffers                7106560 bytes

Database mounted.

ORA-16038: log 2 sequence# 54 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/h/oracle/oradata/orcl/redo02.log'

SQL> I would appreciate any hints on how to resolve this problem.

Thanks,
Owen Received on Sat Sep 01 2007 - 18:21:57 CDT