rman 备份中ORA-19809、ORA-19804问题解决

在我的测试环境中使用rman备份数据库的时候，报如下错误（红色部分）：

oracle@oracle[/oracle]> rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jan 9 09:42:36 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: CNHTM (DBID=1230089073) RMAN> backup database; Starting backup at 09-JAN-10 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=159 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=+DATA/cnhtm/datafile/system01.dbf input datafile fno=00003 name=+DATA/cnhtm/datafile/sysaux01.dbf input datafile fno=00005 name=+DATA/cnhtm/datafile/example01.dbf input datafile fno=00002 name=+DATA/cnhtm/datafile/undotbs101.dbf input datafile fno=00004 name=+DATA/cnhtm/datafile/users01.dbf channel ORA_DISK_1: starting piece 1 at 09-JAN-10 RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/09/2010 09:43:36 ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 52428800 bytes disk space from 1073741824 limitcontinuing other job steps, job failed will not be re-run channel ORA_DISK_1: starting full 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 09-JAN-10 channel ORA_DISK_1: finished piece 1 at 09-JAN-10 piece handle=/oracle/flash_recovery_area/CNHTM/backupset/2010_01_09/o1_mf_ncsnf_TAG20100109T094250_5nhqtbys_.bkp tag=TAG20100109T094250 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/09/2010 09:43:36 ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 52428800 bytes disk space from 1073741824 limit RMAN> exit Recovery Manager complete.

这是flash_recovery_area空间不足的提示

[@more@]

用如下方法检查flash_recovery_area使用情况

oracle@oracle[/oracle]> sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jan 9 09:44:30 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options sys@CNHTM> select * from V$FLASH_RECOVERY_AREA_USAGE; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES ------------ ------------------ ------------------------- --------------- CONTROLFILE 0 0 0 ONLINELOG 0 0 0 ARCHIVELOG 0 0 5 BACKUPPIECE 63.01 .7 7 IMAGECOPY 0 0 0 FLASHBACKLOG 0 0 0 6 rows selected.

检查db_recovery_file_dest_size参数

sys@CNHTM> show parameter recovery NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /oracle/flash_recovery_area db_recovery_file_dest_size big integer 1G recovery_parallelism integer 0

将参数db_recovery_file_dest_size增大为20G

sys@CNHTM> alter system set db_recovery_file_dest_size=20G scope=both; System altered. sys@CNHTM> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

再次备份，没有问题了

oracle@oracle[/oracle]> rman target / Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jan 9 09:45:43 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: CNHTM (DBID=1230089073) RMAN> backup database; Starting backup at 09-JAN-10 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=154 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=+DATA/cnhtm/datafile/system01.dbf input datafile fno=00003 name=+DATA/cnhtm/datafile/sysaux01.dbf input datafile fno=00005 name=+DATA/cnhtm/datafile/example01.dbf input datafile fno=00002 name=+DATA/cnhtm/datafile/undotbs101.dbf input datafile fno=00004 name=+DATA/cnhtm/datafile/users01.dbf channel ORA_DISK_1: starting piece 1 at 09-JAN-10 channel ORA_DISK_1: finished piece 1 at 09-JAN-10 piece handle=/oracle/flash_recovery_area/CNHTM/backupset/2010_01_09/o1_mf_nnndf_TAG20100109T094622_5nhqzhs0_.bkp tag=TAG20100109T094622 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05 channel ORA_DISK_1: starting full 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 09-JAN-10 channel ORA_DISK_1: finished piece 1 at 09-JAN-10 piece handle=/oracle/flash_recovery_area/CNHTM/backupset/2010_01_09/o1_mf_ncsnf_TAG20100109T094622_5nhr1m8l_.bkp tag=TAG20100109T094622 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 09-JAN-10 RMAN>

--end--

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22049049/viewspace-1030420/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22049049/viewspace-1030420/