Question About Flash_Recovery_Area
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Question About Flash_Recovery_Area

  1. #1
    Join Date
    Mar 2010
    Location
    North Carolina, USA
    Posts
    18

    Question About Flash_Recovery_Area

    Hello All,

    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...

    We are using GNU/Linux 2.6.18-92.el5 as our OS.

    Thanks in advance,
    OracleGirl.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    your archive log script might have doing that. Please check the script.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Flash recovery area would be shared by all databases from that oracle home and each database would then write to the location

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

    if you have many databases like SIDNAME1 SIDNAME2 ...you will have directories like

    /usr/app/oracle/flash_recovery_area/{SIDNAME1}/archivelog/
    /usr/app/oracle/flash_recovery_area/{SIDNAME2}/archivelog/

    its just a logical way of organising things by oracle no ?

  4. #4
    Join Date
    Mar 2010
    Location
    North Carolina, USA
    Posts
    18
    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.

    Thanks for the replies....

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Could you please connect to the database via sqlplus and post result of..

    archive log list;
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    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.

  6. #6
    Join Date
    Mar 2010
    Location
    North Carolina, USA
    Posts
    18
    Sure, here it is:

    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination USE_DB_RECOVERY_FILE_DEST
    Oldest online log sequence 1752
    Next log sequence to archive 1754
    Current log sequence 1754

  7. #7
    Join Date
    Mar 2010
    Location
    Los Angeles
    Posts
    20
    Hi Oraclegirl,

    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.

    VJ
    DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width