Tuesday, April 15, 2014

RMAN backup error, RMAN-03009 ORA-19809 ORA-19804

What i have followed:--------
cmd > RMAN
RMAN> connect target /
RMAN> backup database;

Starting backup at 14-APR-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=E:\APP\GURJEET\ORADATA\PROD\USERS01.DBF
input datafile file number=00007 name=E:\APP\GURJEET\ORADATA\PROD\******.DBF
input datafile file number=00003 name=E:\APP\GURJEET\ORADATA\PROD\UNDOTBS01.DBF
input datafile file number=00001 name=E:\APP\GURJEET\ORADATA\PROD\SYSTEM01.DBF
input datafile file number=00002 name=E:\APP\GURJEET\ORADATA\PROD\SYSAUX01.DBF
input datafile file number=00005 name=E:\APP\GURJEET\ORADATA\PROD\EXAMPLE01.DBF
input datafile file number=00006 name=E:\APP\GURJEET\PRODUCT\11.2.0\DBHOME_2\DATABASE\*****.DBF
input datafile file number=00013 name=E:\APP\GURJEET\PRODUCT\11.2.0\DBHOME_2\DATABASE\*****.DBF
channel ORA_DISK_1: starting piece 1 at 14-APR-14
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/14/2014 13:20:42
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 4039114752 limit
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=E:\APP\GURJEET\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2014_04_14\O1_MF_NCSNF_TAG20140414T131547_9NQ4TMXX_.BKP tag=TAG20140414T131547 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/14/2014 13:20:42
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim bytes disk space from limit


Error     :
RMAN-03009: failure of backup command on ORA_DISK_1 channel at
ORA-19809: limit exceeded for recovery files                  
ORA-19804: cannot reclaim  bytes disk space from limit        

Problem   :
FRA (Flash Recovery Area) not have enough space to store the backup file.

Solution  :
1. We need to increase the size of FRA (Flash Recovery Area).
2. You can offer delete command. It will delete old backup files (RMAN RETENTION POLICY).


Explantion solution wise:
FOR SOLUTION 1. We need to increase the size of FRA (Flash Recovery Area).

  • RMAN backup file physically store at FRA (Flash Recovery Area). While installation we assign space from total physical hard drive to FRA.
  • We can also increase and decrease the allocation space to FRA using "alter system" command.

  • After firing command "RMAN> backup database;" i need to wait for some time because the file is being written at location    "E:\app\gurjeet\flash_recovery_area\prod\BACKUPSET\2014_04_15"
         After some time oooopss error

  • How to get estimated size increase for FRA.?. You can get a estimate size for your FRA using below table from column output_bytes/input_bytes.
    select * from V$RMAN_BACKUP_JOB_DETAILS order by 1;

  • After error i checked the trace file which is showing error to the point:
    Errors in file e:\app\gurjeet\diag\rdbms\prod\prod\trace\prod_ora_848.trc:
    ORA-19815: WARNING: db_recovery_file_dest_size of 10156459008 bytes is 99.89% used, and has 11091968 remaining bytes available.
    ************************************************************************
    You have following choices to free up space from recovery area:
    1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
       then consider changing RMAN ARCHIVELOG DELETION POLICY.
    2. Back up files to tertiary device such as tape using RMAN
       BACKUP RECOVERY AREA command.
    3. Add disk space and increase db_recovery_file_dest_size parameter to
       reflect the new space.
    4. Delete unnecessary files using RMAN DELETE command. If an operating
       system command was used to delete files, then use RMAN CROSSCHECK and
       DELETE EXPIRED commands.
    ************************************************************************
    Deleted Oracle managed file E:\APP\GURJEET\FLASH_RECOVERY_AREA\PROD\BACKUPSET\2014_04_15\O1_MF_NNNDF_TAG20140415T124319_9NSQ0JDF_.BKP

  • You can use below command to check used/free space for flash recovery area:
    select name,
    floor(space_limit/1024/1024) "Size_MB",
    ceil(space_used/1024/1024) "Used_MB"
    from v$recovery_file_dest
    order by name
    /


    ALTER SYSTEM SET db_recovery_file_dest_size=12G SCOPE=BOTH ;



SOLUTION 2. You can offer delete command. It will delete old backup files (RMAN RETENTION POLICY).
we can delete old backup file to free up the space or
can set lesser number of days to retain the archivelogs and backup files
RMAN> delete obsolete;

No comments:

Post a Comment

web stats