I was taking backup of database as image copy of size 200G, I
faced ORA errors like ORA-19809, ORA-19804 as shown below
RMAN> run
{
allocate
channel ch1 type disk;
backup
as copy SECTION SIZE 800M database;
release
channel ch1;
}2>
3> 4> 5> 6>
using
target database control file instead of recovery catalog
allocated
channel: ch1
channel
ch1: SID=2330 device type=DISK
Starting
backup at 07-JAN-19
channel
ch1: starting datafile copy
input
datafile file number=00013 name=+DATA/TECH_DB/DATAFILE/tech_tbs_data. 277.996526534
backing
up blocks 1 through 153600
released
channel: ch1
RMAN-00571:
===========================================================
RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03009:
failure of backup command on ch1 channel at 01/07/2019 05:52:11
ORA-19809:
limit exceeded for recovery files
ORA-19804:
cannot reclaim 322123595776 bytes disk space from 107374182400 limit
RMAN>
Below is the solution for the
same
I found database size is 200GB and FRA size is set 100GB only,
which caused this error
commands to check size of FRA
SQL> show parameter db_recovery
NAME
TYPE VALUE
------------------------------------
----------- ------------------------------
db_recovery_file_dest
string
+FLASH
db_recovery_file_dest_size
big integer 100G
SQL>
Command to check size of database and usage of FRA
SQL > select
sum(bytes)/1024/1024/1024 as "Size Of DB" from dba_data_files;
Size Of DB
-------------------------
200
SQL>
col NAME for a10
SQL>
SELECT NAME, round(space_limit/1024/1024/1024,2) TOTAL_GB,
round(space_used/1024/1024/1024,2) USED_GB,
round((space_limit-space_used+space_reclaimable)/1024/1024/1024,2)
AVAILABLE_GB, ROUND((space_used-space_reclaimable)/space_limit * 100,1)
PERCENT_FULL FROM v$recovery_file_dest;
NAME
TOTAL_GB USED_GB AVAILABLE_GB
PERCENT_FULL
----------
---------- ---------- ------------ ------------
+FLASH
100 1.09
99.42 .6
I have changed size of the FRA using DB_RECOVERY_FILE_DEST_SIZE to 250GB, then it worked without any issue.
ALTER SYSTEM SET
DB_RECOVERY_FILE_DEST_SIZE =250G SCOPE=BOTH
Once this is done fire RMAN backup command, it will initiate the backup and will not through this error.
0 comments:
Post a Comment