Answer C,D,F:
A would be correct if it said Online redo log "copies." Copy being the important word. I agree A is incorrect. C is the correct answer because copies of the control file are kept in the FRA. multiplexed = fancy way of saying duplicate/copies
FRA Components
The flash/fast recovery area can contain the following:
Control files: During database creation, a copy of the control file is created in the flash recovery area.
Online redologs: Online redologs can be kept in FRA.
Archived log files: During the configuration of the FRA, the LOG_ARCHIVE_DEST_10 parameter in init.ora file is automatically set to the flash recovery area location. Archived log files are created by ARCn processes in the flash recovery area location and the location defined by LOG_ARCHIVE_DEST_n.
Flashback logs: Flashback logs are kept in the flash recovery area when flashback database is enabled.
Control file and SPFILE backups: The flash recovery area also keeps the control file and SPFILE backups, which is automatically generated by Recovery Manager (RMAN) only if RMAN has been configured for control file autobackup.
Datafile copies: The flash recovery area also keeps the datafile copies.
RMAN backup sets: The default destination of backup sets and image copies generated by RMAN is the flash recovery area.
The following recovery-related files are stored in the flash recovery area:
— Current control file
— Online redo logs
— Archived redo logs
— Flashback logs
— Control file auto backups
— Datafile and control file copies
— Backup pieces
— Foreign archived redo log
for what is indicated here:
Oracle Recovery Manager (RMAN) can store its backup sets and image copies in the fast recovery area
backup set -> A proprietary RMAN backup format that contains data from one or more data files,
archived redo log files, or control files or server parameter file.
and by discarding the other options, only C, D, F are correct
ACD
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup005.htm
The files in the flash recovery area can be classified as permanent or transient. The only permanent files (assuming these are configured to be stored in the flash recovery area) are multiplexed copies of the current control file and online redo logs. These cannot be deleted without causing the instance to fail. All other files are transient, because Oracle will generally eventually delete these files, at some point after they become obsolete under the retention policy or have been backed up to tape. Transient files include archived redo logs, datafile copies, control file copies, control file autobackups, and backup pieces.
DF is correct and I would go for A. Hence, ADF
I think BC is part of RMAN not by default
https://docs.oracle.com/database/121/ADMQS/GUID-EA0666F4-0EB0-4EB5-AD4C-24F77A64CE9D.htm#ADMQS09113
Oracle creates archived logs and flashback logs in the fast recovery area.
Oracle Recovery Manager (RMAN) can store its backup sets and image copies in the fast recovery area
backup set -> A proprietary RMAN backup format that contains data from one or more data files,
archived redo log files, or control files or server parameter file.
C\D\F
Oracle Database writes all RMAN backups, archive logs, control file automatic backups, and database copies to the fast recovery area.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwlin/about-the-fast-recovery-area-and-the-fast-recovery-area-disk-group.html#GUID-05343E2B-24CF-427E-A068-9AC2104BEF81
Option A is incorrect. By default REDO LOGS arent stored on FRA
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
PerkDizzzle
Highly Voted 5Â years, 3Â months agosoniat
3Â years, 9Â months agoRay520
Most Recent 2Â years, 6Â months agoOracle2020
3Â years, 4Â months agoOracle2020
3Â years, 4Â months agomuchiry
3Â years, 6Â months agoIamGo0ke
3Â years, 7Â months agoodavidrg
4Â years agoodavidrg
4Â years agodancymonkey
4Â years, 3Â months agodancymonkey
4Â years, 3Â months agojoe_doe
4Â years, 4Â months agogmariamg
4Â years, 6Â months agotaiyang
4Â years, 8Â months agoVarlos
5Â years, 8Â months ago