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:
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:
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.
By looking in to the "archive log list", i can say that archive log mode is enabled to the location USE_DB_RECOVERY_FILE_DEST with some specified format ( Not listed).
1) The archive log stuff cannot run on any scheduler.
2) Whenever the redo logfile is filled, it automatically triggers archive log job (ARC) which will write the archive log file.
3) Whenever you use 'swtich log file' will trigger ARC.
I think this info helps you. If you have any query please let me know.
Reply With Quote
Bookmarks