Flash Recovery Area Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Flash Recovery Area Problem

  1. #1
    Join Date
    May 2007
    Posts
    5

    Flash Recovery Area Problem

    Dear All,

    I am facing problem in flash recovery area.

    The version and patch release of the Oracle database server is
    Oracle 10g 10.2.0.1.0

    The version and patch of the operating system is
    Red Hat Enterprise Linux AS release 4 (Nahant Update 2) 2.6.9 22.ELsmp (32-bit)

    The database is in archive mode.
    Flashback database feature is enabled.


    I have set db_recovery_file_dest_size=20G

    em shows that 18 GB of flash recovery area is used by Archive log ,while upon checking physically the size of archive log folder is only 3 GB which is not understandable.

    Can somebody help me to solve this problem?

    mia

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    have you deleted files just by using the OS instead of the database?

  3. #3
    Join Date
    May 2007
    Posts
    5

    Re: Flash Recovery Area Problem

    yes, i have manually deleted archivelog folders from flash recovery area

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well dont do that - use the database commands or it wont know that you have done it

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