Oracle Database Discussions

My 10.2.0.3 physical standby produced the below errors, although it remained up. I am wondering if I ran into Bug 6432837, except “select FLASHBACK_ON from V$DATABASE” returns “NO”. I was able to increase the size of DB_RECOVERY_FILE_DEST_SIZE to get around it. However, I fear I have only prolonged the problem, since I have not a viable work around. I’m using the Grid Control to administer both Primary and Standby. It doesn’t seem to allow me to back up the standby, nor do I know how to crosscheck archive logs.

Ideas? Suggestions?

************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
****Creating archive destination file : /u06/archive/PROD/PROD1/archivelog/2008_12_05/o1_mf_1_110223_1_.arc (10244 blocks)
Fri Dec 5 17:49:04 2008
Errors in file /u01/app/oracle/product/10.2.0/admin/PROD/udump/prod_rfs_21541.trc:
ORA-00270: error creating archive log /u06/archive/PROD/PROD1/archivelog/2008_12_05/o1_mf_1_110223_%u_.arc
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 5244928 bytes disk space from 40531656704 limit
Fri Dec 5 17:49:04 2008
Errors in file /u01/app/oracle/product/10.2.0/admin/PROD/udump/prod_rfs_21541.trc:
ORA-00270: error creating archive log /u06/archive/PROD/PROD1/archivelog/2008_12_05/o1_mf_1_110223_%u_.arc
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 5244928 bytes disk space from 40531656704 limit
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[253|http://forums.oracle.com/forums/]: Assigned to RFS process 21543
RFS[253|http://forums.oracle.com/forums/]: Identified database type as 'physical standby'
Fri Dec 5 17:49:07 2008
Errors in file /u01/appORA-19815: WARNING: db_recovery_file_dest_size of 40531656704 bytes is 99.99% used, and has 5241344 remaining bytes available.

SQL> 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 100 0 7340
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0

6 rows selected.

SQL> select * from v$recovery_file_dest;

NAME
-----
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
-----
----------
-----
---------------
/u06/archive/PROD
4.0532E+10 4.0531E+10 5241344 7340