Home » RDBMS Server » Server Administration » deleting files in recovery area
deleting files in recovery area [message #215410] Mon, 22 January 2007 03:19 Go to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Hi all,
I got alert message in OEM, that my oracle database has the
recovery area full in 95 % .
So I don't know how to clean this this area or how to solve this problem.
I'm not using RMAN.
Any help welcome.
thanks
koff

Re: deleting files in recovery area [message #215450 is a reply to message #215410] Mon, 22 January 2007 06:03 Go to previous messageGo to next message
cbruhn2
Messages: 41
Registered: January 2007
Member
Perhaps you should consider using RMAN. It could make the deletions for you. Cool
I suppose its archive log files that's "harming" your diskfree.
Just delete the oldest ones. If you're on Unix you could use find with option ctime or mtime.
Otherwise go into the archivelog directory and delete the oldest files.
I assume that you actually have a valid backup of the database. Then you just need archived redolog files from after the backup you want to apply.
Say you take backup everyday. In order to restore the database using a backup 10 days ago you only need archive logs with a timestamp never than 10 days ago.

Best regards.
Re: deleting files in recovery area [message #215459 is a reply to message #215410] Mon, 22 January 2007 06:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Flash_recovery_area is used for Backup set , Archive log , flashback, Autobackup.
for delete backup from flash_recovery_area
connect to RMAN.
rman>report oboslete;
rman>delete oboslete;
or
rman>crosscheck database backup;
rman>crosscheck archivelog all;
rman>delete expired backup;
rman>delete expired archivelog all;

after that check V$RECOVERY_FILE_SIZE view

regards
Taj
Re: deleting files in recovery area [message #215477 is a reply to message #215459] Mon, 22 January 2007 07:48 Go to previous messageGo to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
user52 wrote on Mon, 22 January 2007 13:42
Hi,
Flash_recovery_area is used for Backup set , Archive log , flashback, Autobackup.
for delete backup from flash_recovery_area
connect to RMAN.
rman>report oboslete;
rman>delete oboslete;
or
rman>crosscheck database backup;
rman>crosscheck archivelog all;
rman>delete expired backup;
rman>delete expired archivelog all;

after that check V$RECOVERY_FILE_SIZE view

regards
Taj



Thanks form your answers.
As I wrote, I didn't configure RMAN in my database. so I can't use RMAN.
Is there others way to reduce size in my Flash_recovery_area ?
thanks again
koff
Re: deleting files in recovery area [message #215480 is a reply to message #215477] Mon, 22 January 2007 07:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Is your database running in archivelog or noarchivelog mode.

regards
Taj
Re: deleting files in recovery area [message #215495 is a reply to message #215477] Mon, 22 January 2007 09:32 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You don't actually have to be backing up with RMAN to manage the flash_recovery_area. Once you have the archive logs backed up, simply issue the following:

Launch RMAN as follows:
C:\> set oracle_sid=<sid_name>
C:\> rman target /

Once in RMAN issue the following:
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
Previous Topic: IGNORE COMMENTS IN EXTERNAL TABLE
Next Topic: RMAN HOT BACKUP
Goto Forum:
  


Current Time: Wed Dec 07 20:19:29 CST 2016

Total time taken to generate the page: 0.08542 seconds