RMAN ORA-19804: cannot reclaim 3838464 bytes disk space from 2147483648 limit

在用rman 测试恢复的时候遇到

ORA-19804: cannot reclaim 3838464 bytes disk space from 2147483648 limit

 

原来是归档空间不够了，重新设置log_archive_dest_1后，问题解决。

RMAN> RECOVER DATABASE;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/10/2011 14:02:07
ORA-19870: error reading backup piece d:\BACKUP\ORCL76406633413682BIMOLEGU
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 3838464 bytes disk space from 2147483648 limit

 

C:\Documents and Settings\liangwei>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Oct 10 14:05:58 2011

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter db_recovery_file_dest

NAME                                           TYPE        VALUE
------------------------------------      -----------   ------------------------------
db_recovery_file_dest                string      D:\oracle\product\flash_recovery_ar                                  

db_recovery_file_dest_size       big integer 2G

 

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     34835
Next log sequence to archive   34841
Current log sequence           34841

SQL> select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable,
  2      number_of_files as "number" from v$flash_recovery_area_usage;

FILE_TYPE          USED RECLAIMABLE     number
------------ ---------- ----------- ----------
CONTROLFILE           0           0          0
ONLINELOG         14.65           0          3
ARCHIVELOG            0           0          0
BACKUPPIECE      177.26       33.93        218
IMAGECOPY             0           0          0
FLASHBACKLOG          0           0          0

6 rows selected.

SQL> alter system set log_archive_dest_1='LOCATION=F:\oradata\orcl\frarea' scope=both ;
System altered.

继续
RMAN> RECOVER DATABASE;

ok!