[Solved] Issue: ORA-19809: limit exceeded for recovery files

Ao tentar realizar o backup do banco de dados, a seguinte mensagem é reportada:

[oracle@oel8 ~]$ rman target /
 
Recovery Manager: Release 18.0.0.0.0 - Production on Fri Mar 12 05:34:02 2021
Version 18.3.0.0.0
 
Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: RMANDB (DBID=3825250984, not open)
 
RMAN> BACKUP DATABASE;
 
Starting backup at 2021-03-12:05:34:21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=45 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=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
input datafile file number=00003 name=/oracle/dados/RMANDB/datafile/o1_mf_sysaux_h8nyq35q_.dbf
input datafile file number=00004 name=/oracle/dados/RMANDB/datafile/o1_mf_undotbs1_h8nyrjdr_.dbf
input datafile file number=00005 name=/oracle/dados/RMANDB/datafile/ts_cortex_catalog.dbf
input datafile file number=00007 name=/oracle/dados/RMANDB/datafile/o1_mf_users_h8nyrkn7_.dbf
channel ORA_DISK_1: starting piece 1 at 2021-03-12:05:34:24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/12/2021 05:35:09
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 67108864 bytes disk space from 734003200 bytes limit
 
RMAN>

É possível notarmos que a FRA está limitada até 700MB, e por conta disso o RMAN não consegue concluir a sua operação:

[oracle@oel8 oracle]$ sqlplus / as sysdba
 
SQL*Plus: Release 18.0.0.0.0 - Production on Fri Mar 12 05:38:12 2021
Version 18.3.0.0.0
 
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
 
SQL> SHO PARAMETER RECOVERY
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /oracle/fra
db_recovery_file_dest_size           big integer 700M
recovery_parallelism                 integer     0
remote_recovery_file_dest            string
SQL>

Aumentando o valor da FRA:

SQL> ALTER SYSTEM SET db_recovery_file_dest_size=2G;
 
System altered.

Executando novamente o backup, agora com sucesso:

[oracle@oel8 oracle]$ rman target /
 
Recovery Manager: Release 18.0.0.0.0 - Production on Fri Mar 12 05:41:07 2021
Version 18.3.0.0.0
 
Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: RMANDB (DBID=3825250984, not open)
 
RMAN> BACKUP DATABASE;
 
Starting backup at 2021-03-12:05:41:16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7 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=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
input datafile file number=00003 name=/oracle/dados/RMANDB/datafile/o1_mf_sysaux_h8nyq35q_.dbf
input datafile file number=00004 name=/oracle/dados/RMANDB/datafile/o1_mf_undotbs1_h8nyrjdr_.dbf
input datafile file number=00005 name=/oracle/dados/RMANDB/datafile/ts_cortex_catalog.dbf
input datafile file number=00007 name=/oracle/dados/RMANDB/datafile/o1_mf_users_h8nyrkn7_.dbf
channel ORA_DISK_1: starting piece 1 at 2021-03-12:05:41:18
channel ORA_DISK_1: finished piece 1 at 2021-03-12:05:42:23
piece handle=/oracle/fra/RMANDB/backupset/2021_03_12/o1_mf_nnndf_TAG20210312T054118_j4pb9gv3_.bkp tag=TAG20210312T054118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 2021-03-12:05:42:23
 
Starting Control File and SPFILE Autobackup at 2021-03-12:05:42:24
piece handle=/oracle/fra/RMANDB/autobackup/2021_03_12/o1_mf_s_1066973440_j4pbck5m_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-03-12:05:42:27
 
RMAN>

Leave a Comment

Your email address will not be published.