cannot reclaim 52428800 bytes disk space from 4070572032 limit

不会游泳的鱼丶發表於2024-07-24
AIMIT

RMAN> backup database;

Starting backup at 24-JUL-24
using channel ORA_DISK_1
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=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00006 name=/home/oracle/datafile/test_tablespace.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/XTBA.DBF
channel ORA_DISK_1: starting piece 1 at 24-JUL-24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/24/2024 21:50:13
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 4070572032 limit

SQL> ALTER SYSTEM SET db_recovery_file_dest_size='10G' SCOPE=BOTH;

System altered.

RMAN> backup database;

Starting backup at 24-JUL-24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=139 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=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00006 name=/home/oracle/datafile/test_tablespace.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/XTBA.DBF
channel ORA_DISK_1: starting piece 1 at 24-JUL-24
channel ORA_DISK_1: finished piece 1 at 24-JUL-24
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2024_07_24/o1_mf_nnndf_TAG20240724T215108_mb21pdvh_.bkp tag=TAG20240724T215108 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 24-JUL-24

Starting Control File and SPFILE Autobackup at 24-JUL-24
piece handle=/home/oracle/backup/controlfile_c-1689491169-20240724-00 comment=NONE
Finished Control File and SPFILE Autobackup at 24-JUL-24

相關文章