Exam 1z0-083 All QuestionsBrowse all questions from this exam
Question 31

You issued this command:

RMAN> BACKUP RECOVERY FILES;

Which two are true? (Choose two.)

    Correct Answer: C, E

    The command 'RMAN> BACKUP RECOVERY FILES;' backs up all Oracle recovery files in the current fast recovery area (FRA) that have not been backed up already. This is due to the default backup optimization which skips already backed-up files unless 'FORCE' is specified. This includes control file autobackups, archived redo log files, and data file copies. Additionally, the backups can be written to either disk or SBT (tape). To backup to disk explicitly, the 'TO DESTINATION' clause must be specified.

Discussion
monad2006Options: AC

I think: AC

proact

A is wrong as USER_TABLESPACE doesn't specify a default tablespace, but specifies which tablespaces are available in the new PDB.

SimoneFOptions: AC

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

SimoneF

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.

Heat418

I vote for AC as well.

MartinDBA2Options: CD

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

FelipeC

if you I have a problem with A&C which states "not backed up yet", think about D which states "ALL" ...., flashback logs are never backed up

Felix_brOptions: AC

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!

antonica

an example of recovery files? please

ShunpinOptions: AC

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.

LEOC71Options: AC

"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

piontkOptions: AC

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

kaka321Options: DE

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

ErikJanssen

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

ErikJanssen

E is also wrong I think; When backing up to disk, one needs to specify a toDestination clause which is not mentioned.

GuhborgesOptions: DE

D, E 100%

ScottLOptions: AC

A,C Should be correct

_gio_Options: AC

" 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

ErikJanssen

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

vkraOptions: AC

AC should be correct

hilaireOptions: AC

AC correct

hilaireOptions: AC

AC coorect

flaviogcmeloOptions: DE

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.