Oracle Database Discussions

Hi.

I am getting the below errors (at the end) when trying to backup the database using RMAN.


The directory structure is

E:\oracle\TEST
E:\oracle\TEST\flash_recovery_area
E:\oracle\TEST\flash_recovery_area\arch --> HAS ARCHIVE FILES
E:\oracle\TEST\flash_recovery_area\TEST
E:\oracle\ATEST\flash_recovery_area\TEST\BACKUPSET --> RMAN backup sets
E:\oracle\TEST\flash_recovery_area\TEST\ONLINELOG --> This is empty.

D:\oracle\product\10.2.0\ is oracle home
It has:
D:\oracle\product\10.2.0\admin
D:\oracle\product\10.2.0\db1
D:\oracle\product\10.2.0\oradata
D:\oracle\product\10.2.0\oradata\test has data files.

1) I created this database using OUI and DBCA and I have a feeling that this structure is somewhat convoluted. Could you let me know if this needs to be changed?

2) Secondly, the RMAN error. The entire size of E:\oracle\TEST\flash_recovery_area is now only 1.74 GB yet I am getting this error.

I deleted old archive logs from E:\oracle\TEST\flash_recovery_area\arch . Currently it has only arch logs for seven days. Next I issued delete expired archivelog all command. Right now crosscheck archivelog all finds only 40 archive logs..

and increased db_recovery_file_dest_size to 10GB. alter system set db_recovery_file_dest_size=10000M scope=both;




select name
, floor(space_limit / 1024 / 1024) "Size MB"
, ceil(space_used / 1024 / 1024) "Used MB"
from v$recovery_file_dest
order by name
/

This query is returning the use space as 6GB. However physically only 1.74 GB is currenly used. Please let me know the way forward. Appreciate in advance.




channel ORA_DISK_1: starting piece 1 at 09-JUN-09
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/09/2009 17:56:
15
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 10485760000 limit
continuing 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-JUN-09
channel ORA_DISK_1: finished piece 1 at 09-JUN-09
piece handle=E:\ORACLE\TEST\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2009_06_09\
O1_MF_NCSNF_TAG20090609T175224_52XPN0Y9_.BKP tag=TAG20090609T175224 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/09/2009 17:56:
15
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 10485760000 limit
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/09/2009 17:54:
19
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 10485760000 limit

RMAN>