Results 1 to 4 of 4

Thread: Backup Location

  1. #1
    Join Date
    Dec 2004
    Posts
    25

    Unanswered: Backup Location

    1) Is it possible to set the " db_recovery_file_dest " parameter to TWO location?

    2) Can the flash recovery area size be auto extend?

  2. #2
    Join Date
    May 2004
    Location
    Germany
    Posts
    25
    1)
    No, you can only move the flash recovery area. Oracle starts using the new area immediatly.

    2)
    No, the DB_RECOVERY_FILE_DEST_SIZE is a limit which will not be exceeded even if you use ASM. But it is only a upper limit. The space is not allocated immediatly.

  3. #3
    Join Date
    Dec 2004
    Posts
    25
    If I need to change the flash recovery area to another location, does it required my DB to restart?
    Or I can just use ALTER SYSTEM command to execute the changes?

  4. #4
    Join Date
    Feb 2005
    Location
    Leesburg, VA
    Posts
    42
    db_recovery_file_dest is a dynamic parameter, so you wont have to restart your DB to change it.
    Steven Karam
    Oracle 10g Certified Master
    Web: OrclDBA.com
    Email: steve@orcldba.com

Posting Permissions

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