https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/using-RMAN-in-oracle-data-guard-configurations.html#GUID-66665A86-0B71-41FE-BED0-B9992A405C35
"To back up all recovery-related files to tape, use the RMAN BACKUP RECOVERY FILES
[...]
This ensures that all current incremental, image copy, and archived log backups on disk are backed up to tape."
and
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/configuring-rman-client-basic.html#GUID-ABA3E439-57C2-4AE7-BCEF-39A6663E7AA2
"RMAN uses backup optimization when the following conditions are true:
[...]
You run [...] BACKUP RECOVERY FILES [...]"
Lead me to believe AC
Sorry for the triple post, it didn't give me immediate results so I thought publication failed.
Anyway, in the first case, it's said that ALL of those files on disk are backed up to tape, so also outside the recovery area (as opposed to "BACKUP RECOVERY AREA").
The second sentence states that backup optimization is turned on with BACKUP RECOVERY FILES: this implies that "the BACKUP command skips backing up files
when the identical file has been backed up to the specified device type."
Since E is wrong cause you need to specify "TO LOCATION" in order to back up to disk in this case:
A and C should be right.
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50
Backs up all recovery files on disk, whether they are stored in the fast recovery area or other locations on disk
The backups can go to SBT or disk
E might have questions - If the backups are not on disk.
"Backs up all recovery files on disk, whether they are stored in the fast recovery area or other locations on disk. "
"By default, backup optimization is enabled for this command even if the CONFIGURE BACKUP OPTIMIZATION setting is OFF" => A:TRUE, C:TRUE
A, C are correct:
About BACKUP RECOVERY FILES: "Backs up all recovery files on disk, whether they are stored in the fast recovery area or other locations on disk. [...] By default, backup optimization is enabled for this command even if the CONFIGURE BACKUP OPTIMIZATION setting is OFF. "
About BACKUP OPTIMIZATION: "Optimization prevents RMAN from backing up a file to a device type if the identical file is already backed up on the device type".
The point that invalidates E is: "The backups can go to SBT or disk. To backup to disk, you must use the TO DESTINATION syntax outlined in toDestSpec. "
Since in this question we do not use TO DESTINATION, we are not backing up to disk.
REF:
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#d11234e4347
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CONFIGURE.html#d27691e2023
I will go for DE. E is 100% correct backup recovery files; can be done on any of tape or disk.
its 100% right that it backs up all oracle files in FRA in the document it does not specified leaving already backed up files. https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50
I think D is wrong; The command enables Rman backup optimization; So only the files not already backed u will be backed up and not all files.
See: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50
"
Backs up all recovery files on disk, whether they are stored in the fast recovery area or other locations on disk. The backups can go to SBT or disk. To backup to disk, you must use the TO DESTINATION syntax outlined in toDestSpec.
Recovery files include full and incremental backup sets, control file autobackups, archived redo log files, and data file copies.
By default, backup optimization is enabled for this command even if the CONFIGURE BACKUP OPTIMIZATION setting is OFF. You can disable backup optimization for RECOVERY FILES by specifying FORCE.
"
from: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50
I found this piece of documentation about backing up RMAN backups very clarifying:
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html#GUID-731ADA67-235E-481D-AC17-9F9067AD55BF
In my opinion files already backed up will be disregarded by the optimized backup function because FORCE was not used. And the backup can be sent either to disk or tape, in this case it will be to tape, if there was the TO DESTINATION clause it would be written to disk.
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50
Backs up all recovery files on disk, whether they are stored in the fast recovery area or other locations on disk. The backups can go to SBT or disk. To backup to disk, you must use the TO DESTINATION syntax outlined in toDestSpec.
By default, backup optimization is enabled for this command even if the CONFIGURE BACKUP OPTIMIZATION setting is OFF. You can disable backup optimization for RECOVERY FILES by specifying FORCE.
In my understanding this mean that only files not backed up will be added.
D is the only correct answer, I have a problem with A&C which states "not backed up yet" as the manual says "all recovery files" which indicates even if they have been backup up previously.
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/BACKUP.html#GUID-73642FF2-43C5-48B2-9969-99001C52EB50
Backs up all recovery files on disk, whether they are stored in the fast recovery area or other locations on disk. The backups can go to SBT or disk. To backup to disk, you must use the TO DESTINATION syntax outlined in toDestSpec.
E is also incorrect as the command given does not include the necessary TO DESTINATION syntax
The RMAN command backup recovery area backs up all files needed for recovery in the flash recovery area. There is a second command, backup recovery files, that backs up all recovery files that are on the disk, wherever they may be (in flash recovery areas or otherwise). The backup recovery files command must also go to an sbt device and cannot go to disk.
Note: The backup recovery area and backup recovery files commands are useful commands when you do your primary backups to disk but want to back up those backup sets to tape at a later date!
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.
monad2006
Highly Voted 4 years, 1 month agoproact
3 years, 9 months agoSimoneF
Highly Voted 3 years, 2 months agoHeat418
2 years agoSimoneF
3 years, 2 months agoantonica
Most Recent 3 months, 3 weeks agoShunpin
7 months, 1 week agoLEOC71
7 months, 2 weeks agopiontk
11 months, 3 weeks agokaka321
1 year agoErikJanssen
11 months, 3 weeks agoErikJanssen
11 months, 3 weeks agoGuhborges
1 year agoScottL
1 year, 2 months ago_gio_
1 year, 2 months agoErikJanssen
1 year, 3 months agovkra
1 year, 5 months agohilaire
1 year, 6 months agohilaire
1 year, 10 months agoflaviogcmelo
2 years, 2 months agoMartinDBA2
2 years, 3 months agoFelipeC
11 months, 3 weeks agoFelix_br
2 years, 9 months ago