Home » RDBMS Server » Backup & Recovery » Backup using OEM error (RHL 4 Oracle 10.2.0)
Backup using OEM error [message #447637] Wed, 17 March 2010 00:19 Go to next message
jxh461
Messages: 185
Registered: March 2005
Senior Member
I am trying to do a backup to disk dataset using OEM.
I keep getting the following error. I already increased my db_recovery_file_dest_size to 8G. What do I need to do to make
this work ?

RMAN> backup incremental level 0 cumulative device type disk tag 'BACKUP_ORCL_000090_031710121430' database include current controlfile;
Starting backup at 17-MAR-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=129 devtype=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/orcl/inventory01.dbf
channel ORA_DISK_1: starting piece 1 at 17-MAR-10
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/17/2010 00:17:59
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 8589934592 limit
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 17-MAR-10
channel ORA_DISK_1: finished piece 1 at 17-MAR-10
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2010_03_17/o1_mf_ncsn0_BACKUP_ORCL_000090_0_5t0sj9o6_.bkp tag=BACKUP_ORCL_000090_031710121430 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/17/2010 00:17:59
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 8589934592 limit
Re: Backup using OEM error [message #447654 is a reply to message #447637] Wed, 17 March 2010 02:02 Go to previous message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-19809: 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.

ORA-19804: 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.

Regards
Michel
Previous Topic: RMAN Backup issue
Next Topic: Restore Performance
Goto Forum:
  


Current Time: Sun Sep 25 19:41:39 CDT 2016

Total time taken to generate the page: 0.15199 seconds