OraFAQ Forum: Server Administration » deleting files in recovery area

Home » RDBMS Server » Server Administration » deleting files in recovery area

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

deleting files in recovery area [message #215410]

Mon, 22 January 2007 03:19

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

Report message to a moderator

Re: deleting files in recovery area [message #215450 is a reply to message #215410]

Mon, 22 January 2007 06:03

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.

Report message to a moderator

Re: deleting files in recovery area [message #215459 is a reply to message #215410]

Mon, 22 January 2007 06:42

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

Report message to a moderator

Re: deleting files in recovery area [message #215477 is a reply to message #215459]

Mon, 22 January 2007 07:48

koff10
Messages: 58
Registered: December 2006
Location: france

Member

user52 wrote on Mon, 22 January 2007 13:42

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

Report message to a moderator

Re: deleting files in recovery area [message #215480 is a reply to message #215477]

Mon, 22 January 2007 07:55

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

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

regards
Taj

Report message to a moderator

Re: deleting files in recovery area [message #215495 is a reply to message #215477]

Mon, 22 January 2007 09:32

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;

Report message to a moderator

Previous Topic:	IGNORE COMMENTS IN EXTERNAL TABLE
Next Topic:	RMAN HOT BACKUP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:31:04 CDT 2024