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

From: Marc Bruinsma <marc.bruinsma_at_chello.nl>
Date: Sun, 02 Sep 2007 02:18:05 +0200
Message-ID: <9jnCi.1111$9V2.701@amstwist00>

owensmith99_at_gmail.com wrote:

> 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

Simple:

[oracle_at_oms]$ oerr ora 19809

19809, 00000, "limit exceeded for recovery files"

//*Cause: The limit for recovery files specified by the
//        DB_RECOVERY_FILE_DEST_SIZE was exceeded.
//*Action:The error is accompanied by 19804. See message 19804 for further
//        details.

[oracle_at_oms chkpw]$ oerr ora 19804
19804, 00000, "cannot reclaim %s bytes disk space from %s limit"

// *Cause: Oracle cannot reclaim disk space of specified bytes from the
//         DB_RECOVERY_FILE_DEST_SIZE limit.
// *Action: There are five possible solutions:
//          1) Take frequent backup of recovery area using RMAN.
//          2) Consider changing RMAN retention policy.
//          3) Consider changing RMAN archivelog deletion policy.
//          4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
//          5) Delete files from recovery area using RMAN.

So pick one (or more) out of five, but I would suggest start with option 4, that's the quickest. Received on Sat Sep 01 2007 - 19:18:05 CDT