Home » RDBMS Server » Server Administration » Flash Recovery Area (Oracle 10g)
Flash Recovery Area [message #340953] Fri, 15 August 2008 03:05 Go to next message
parkarfaisal
Messages: 13
Registered: August 2008
Location: Kuwait
Junior Member
I am using Oracle 10g. Just recently i enabled Archiving. My location for Archive logs is the Flash Recovery Area. Every day i physically remove the previous day logs and copy it in another location but still the flash recovery area usage is not updated. Please let me know how i can reclaim the used Flash Recovery Area.

Report message to a moderator

Re: Flash Recovery Area [message #340992 is a reply to message #340953] Fri, 15 August 2008 08:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should not physically remove the files. If you are going to do anything, you can copy them elsewhere and let FRA remove the files when necessary. The other option may be to specify another archive log destination in addition to the FRA.

To get out of the situation you are in, perform the following:

RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;

Report message to a moderator

Re: Flash Recovery Area [message #340995 is a reply to message #340992] Fri, 15 August 2008 08:15 Go to previous messageGo to next message
parkarfaisal
Messages: 13
Registered: August 2008
Location: Kuwait
Junior Member
when i specify a different archive destination it doesnt create seperate folders datewise daily which is done when i use default FRA.

Is it possible to have daily datewise folders created when i specify a different location other than default FRA destination.

Report message to a moderator

Re: Flash Recovery Area [message #340997 is a reply to message #340995] Fri, 15 August 2008 08:18 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That is a feature of FRA. If you want that functionality outside of the FRA, you'd have to do that yourself.

Report message to a moderator

Re: Flash Recovery Area [message #341081 is a reply to message #340997] Sat, 16 August 2008 01:39 Go to previous message
parkarfaisal
Messages: 13
Registered: August 2008
Location: Kuwait
Junior Member
Thank you very much for yor reply.

Report message to a moderator

Previous Topic: Datafile Recovery
Next Topic: Table Size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 07:18:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.