If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Question About Flash_Recovery_Area

I am a bit new to 11g. In having a look at an already-existing 11.1.0.7.0 database (one I did not set up), I noticed that the flashback_recovery_area has a definition like this:

/usr/app/oracle/flash_recovery_area

But the actual archived redo logs are being written to:

/usr/app/oracle/flash_recovery_area/SIDNAME/archivelog/

Each day the archived redo logs are being written to the appropriate date-labelled subdirectory, but I don't see any cron jobs or scripts which are setting this up.

So my question is, is this a new feature in 11g, where Oracle creates the subdirectories in the background? I have Googled "flash_recovery_area" but have not found anything specific to these directories...

Yes, I can see that it would make sense for Oracle to set up the SIDNAME/archivelog subdirectories...but, in my original post, it looks like the whole string I typed, did not display. There are date subdirectories being created, one for each day, after the archivelog directory:

/usr/app/oracle/flash_recovery_area/{SIDNAME}/archivelog/{DATE}

(hope that displays what I am talking about)

for example:

/usr/app/oracle/flash_recovery_area/{SIDNAME}/archivelog/2010_03_22

and it is these date-named subdirectories that I am really curious about. I don't see any cron jobs which are creating them, so I just thought I'd ask in case someone else has seen this before.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.