| Backup using OEM error [message #447637] |
Wed, 17 March 2010 00:19  |
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  |
 |
Michel Cadot
Messages: 68643
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
