Flash Recovery Area store & manage files related to backup & recovery - Oracle DBA

Q.  Which is the location of the Oracle Database that can store and manage files related to backup and recovery?
- Published on 12 Aug 15

a. Flash Recovery Area
b. Managing the System Global Area (SGA)
c. Both A & B
d. None of the above

ANSWER: Flash Recovery Area

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -Backup and recovery procedures protect your database against data loss and reconstruct the data, should loss occur.

    -Flash Recovery Area - The flash recovery area is associated with the parameter DB_RECOVERY_FILE_DEST.
    -It simplifies the ongoing administration of the database by automatically naming recovery-related files, retaining them as long as they are needed for restore and recovery activities and deleting them when they are no longer needed to restore your database and space is needed for some other backup and recovery-related purpose.

    -Managing the System Global Area (SGA) - It is a group of shared memory areas that are dedicated to an Oracle instance.
    -All the Oracle processes use the SGA to hold the information.
    -It is used to store incoming data.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲