Database Backup and Recovery (MOSC)

MOSC Banner

ORA-19809 Incremental Backup Failing

edited Sep 1, 2014 5:59PM in Database Backup and Recovery (MOSC) 4 commentsAnswered

Hi,

Oracle 11.2.0.1 on Ubuntu 14.04

I have a cron job running my backup once a day and I cannot figure out why I am getting this error set :

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 29827792896 bytes disk space from 858993459200 limit

RMAN-03009: failure of backup command on ORA_DISK_3 channel at 08/12/2014 03:17:57

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 34303115264 bytes disk space from 858993459200 limit

RMAN-03009: failure of backup command on ORA_DISK_3 channel at 08/12/2014 03:17:35

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 34331164672 bytes disk space from 858993459200 limit

I ran :

SQL> select  name,  (space_limit/1024/1024) ||'MB' as Space_Limit, (space_used/1024/1024)||'MB' as Space_Used from  v$recovery_file_dest;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center