(Q) What initialization parameters are used to configure a Fast Recovery Area?
DB_RECOVERY_FILE_DEST
- specifies default location for fast recovery area.DB_RECOVERY_FILE_DEST_SIZE
- specifies (in bytes) the hard limit on the total space to be used by target database recovery files created in the fast recovery area- (optional)
DB_FLASHBACK_RETENTION_TARGET
-Specifies the upper limit (minutes) on how far back in time the database may be flashed back.
(Q) Can you configure the Fast Recovery Area on an ASM disk group?
- Yes
(Q) How large should you configure the Fast Recovery Area?
- At an ABSOLUTE MINIMUM, it should be large enough to containt the archived redo logs not yet on tape.
- Scenario:
- If you use incrementally updated backups and set the backup retention policy to REDUNDANCY 1, you can determine the size of the fast recovery area as below:

No comments:
Post a Comment