Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    46

    Unanswered: Relationship Between Recovery Area size and physical disk space

    Dear All,

    I would be very grateful if anybody can educate me on the relationship between the size of db_recovery_area and physical disk space.

    Thus, suppos I allocate to db_recovery_area_size more space than is available on Physical disk what will result??

    My system is Oracle 10gr2 and hosted on windows server 2003 R2

    Thanks in advance

    F.K

  2. #2
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Since there are no parameters db_recovery_area and db_recovery_area_size, I assume you are talking about DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE (and I think the name explains the relationship).

    Thus, suppos I allocate to db_recovery_area_size more space than is available on Physical disk what will result??
    You will get the "ORA-19804: cannot reclaim string bytes disk space from string limit" error.
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  3. #3
    Join Date
    Mar 2009
    Posts
    46
    Hi Magicwand,
    thanks for your response but I think you did not address the issue I raised

    What I mean is suppose I have 10G space on my physical disk, can I assign more than 10G (sey 15G) to db_recovery_file_dest_size?? And what is result if I do that??


    I hope you got me right now.

    F.K

Posting Permissions

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