Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
A.
A target database's persistent RMAN configuration settings are always stored in the target's control file
B.
Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
C.
Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.
D.
The RMAN SHOW ALL command displays only settings with nondefault values.
E.
A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
F.
The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
G.
A DBA must specify either a redundancy retention policy or a recovery window retention policy.
F is correct, I try to modify an RMAN configuration and v$rman_configuration shows only the modification.
A is correct because information are always stored in control file even if you use rman catalog
C is correct (delete obsolete)
I would say correct is A,C,E
E is correct --> RMAN performs resynchronizations automatically as needed when you execute certain commands, including BACKUP. You can also manually perform a full resynchronization using the RESYNC CATALOG command.
F is incorrect --> V$RMAN_CONFIGURATION lists information about RMAN persistent configuration settings.
Agree F should be incorrect. As stated in Oracle 19c database reference, V$RMAN_CONFIGURATION lists information about RMAN persistent configuration settings.
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-RMAN_CONFIGURATION.html#GUID-13D7B8D1-C7B7-43EC-B176-90CCB9A4D647
AFG
C: RMAN backup in FRA never get deleted AUTOMATICALLY. they have to either delete manually or using script based on retention policy.Whereas Flashback logs get automatically deleted based on availability of free space or if FRA parameter db_flashback_retention_target value reduced(19c feature).
G cannot be correct - as Oracle will provide a default value, when a DB is created. The DBA does not "need" to specify either of these values.
I think that C is not written perfectly, but it does imply that the use of the "DELETE OBSOLETE" statement will automatically remove every non-needed backup file that lies outside of the retention policy period.
So, I believe that ACF is correct.
C is correct : If you use a fast recovery area as your only disk-based backup destination, then you never have to delete obsolete backups from disk. The fast recovery area keeps files as specified by the retention policy, and deletes them only when space is needed.
ACF Why does the dba need to specify the retention policy? it's not necessary, you can use the default values also.
upvoted 7 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.
RinD
Highly Voted 2 years, 3 months agomichael_live
Highly Voted 2 years, 9 months agoScottL
Most Recent 2 months, 1 week ago_gio_
2 months, 2 weeks agojareach
5 months, 1 week agohilaire
10 months, 1 week agoYennism
1 year, 6 months agokameni
1 year, 10 months agoPortlandFighters
1 year, 9 months agowqui
1 year, 10 months agoKishor123
1 year, 11 months agoxRodge
1 year, 11 months agoKishor123
1 year, 11 months agobrolem
1 year, 2 months agopgtips
2 years, 10 months agoald85
3 years agoveginha
3 years ago