Flash Recovery Area full

oracle-11g-r2oracle-asmrecoveryrman

I have oracle 11g that runs on Linux serve.
I have a Flash Recovery Area, I backup my archive logs to another location.

presently I have very little space left in my Flash Recovery Area (FRA) thereby resulting in my archivelog getting filled up quickly and making my DR unable to receive Redo logs.

I wish to free some space in the FRA.
please which of the directories in the FRA Can I touch in order to free some space.

Here is the information of the directories in my FRA
autobackup 3150
archivelog 6962
controlfile 81
datafile 567774
onlinelog 13338

I know I can't touch the control file.
am new here and afraid to mess things up.

if I can't delete files from any of these directories to free some space, what is my possible alternative of getting some more space in my FRA.

Best Answer

Keep in mind that Oracle manages the FRA space and will delete files if they are no longer needed, to make space. You can have FRA 90% used, and it's OK. For example, archive logs may be backed up to tape, but they will remain in the FRA for faster access if the space is not needed by other files.

First - check for reclaimable space with SELECT * FROM V$RECOVERY_FILE_DEST;. The NAME field will either be a disk path, or an ASM disk group. If space is reclaimable, then the files should automatically be cleaned up.

Second - check for free space on the device that stores your FRA (NAME from V$RECOVERY_FILE_DEST). If you have space, you can increase the amount of space you allow FRA to use (see DB_RECOVERY_FILE_DEST_SIZE). https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams061.htm#REFRN10235

DB_RECOVERY_FILE_DEST_SIZE specifies (in bytes) the hard limit on the total space to be used by target database recovery files created in the flash recovery area.

More information is needed to know if any of the files can be cleaned up.

Related Solutions

Duplicating a Database with RMAN

If my source database uses SPFILE then do I have create a PFILE from the SPFILE?

Yes, you need to create a temporary PFILE to use while duplicating the database. You will later switch the new instance to use the SPFILE.

Use

CREATE PFILE = 'path/to/pfile' FROM SPFILE;

You only need to create directories that are referenced in the PFILE or SPFILE. Which directories need to be created?

You will start the database as NOMOUNT to begin the duplication. This means the controlfiles will not be read, and so you don't need to have the directories in which the datafiles reside present in your new host. However, the directories references in the parameter files must be present. From your transcript,

DB11G.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
*.audit_file_dest='/u01/app/oracle/admin/DB11G/adump' 
*.control_files='/u01/app/oracle/oradata/DB11G/control01.ctl','/u01/app/oracle/oradata/DB11G/control02.ctl'#Restore Controlfile
*.db_recovery_file_dest='/u01/app/oracle/fra'
*.diagnostic_dest='/u01/app/oracle'
*.log_archive_dest_1='location=/u01/app/oracle/archive_logs'

You may find this chapter of the documentation useful: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#i1006474

Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]

The db_recovery_file_dest includes a variety of files, including online AND archived redo log files; take a look at the Oracle Backup and Recovery User's Guide chapter 5 to find out the best solution; disabling db_recovery_file_dest is not a good idea. You can try

RMAN> report obsolete;

RMAN command to see what can be deleted. Then do a delete obsolete to delete them. Do you have any guaranteed restore points defined?

RMAN> list restore point all;

If you see any results with type GUARANTEED, if they are no longer needed, remove them:

SQL> DROP RESTORE POINT before_app_upgrade;

Is flashback database enabled?

Best Answer

Related Solutions

Duplicating a Database with RMAN

Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]

Related Question