Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)
Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)
An RMAN archival backup with the RESTORE POINT clause involves several specific characteristics. The SPFILE is included in the archival backup as it is essential for database recovery, making option B correct. Archival backups ensure that archive logs are retained if needed to recover the database to a consistent state when the backup is restored, so option D is also correct. Furthermore, archival backups with the KEEP clause make the backups exempt from the configured RMAN retention policy, effectively overriding it, which makes option E correct.
E: Not sure about 'ARCHIVAL' attribute. I use 'keep until' or 'keep forever', not 'ARCHIVAL' I think that BDF is correct answer. https://www.oracledistilled.com/oracle-database/backup-and-recovery/archival-backups-rman-backups-for-long-term-retention/
E: is incorrect. F is correct. You can create archival backups with KEEP. Clause KEEP specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy. RMAN does not consider backup pieces with the KEEP option when computing the retention policy. If available, RMAN uses these backups for disaster recovery restore operations, but their purpose is to produce a snapshot of the database that can be restored on another system for testing or historical usage. Note: You cannot use KEEP to override the retention policy for files stored in the fast recovery area. If you specify KEEP when backing up to the recovery area, then RMAN issues an error. https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/keepOption.html#GUID-36E9008E-48A5-4AB9-8C9D-2D477342594B
F is incorect too - If you specify KEEP when backing up to the recovery area, then RMAN issues an error.
I agree, BDE
BDE is correct answer
I think BEG https://oraclemantra.wordpress.com/2013/04/25/archival-backups/
G is wrong since it doesn't "always" require recovery catalog. Its is required only when command is using "keep forever" clause.
G is correct, since the question is about "Restore Point" therefore you have to use either "Keep forever" or "Keep until" and Hence Correct Answer is B,E,G
My mistake Recovery Catalog is only required with "Keep Forever", other clause "Keep Until" do not require a Recovery Catalog.
I agreed with BDE
Some of facts about archival backup: • Use KEEP clause to create archival backup • Use RESTORE POINT clause to assign a name to a specific SCN ○ It create a consistency point in the control file ○ The SCN is captured after the data file backup complete • They are either considered obsolete only after a specific time that you specify or never considered obsolete • Any files that need to restore this backup (to a consistent state) are kept, include data files, control files, SPFILE, archived log files, and relevant autobackup files (so what are relevant autobackup files) • Cannot be stored in FRA, DBA must provide a FORMAT clause to specify a different location • Recovery catalog is required to create archival backup of an OPEN DB. Without recovery catalog, you must put the DB in MOUNT state • Without recovery catalog, you cannot use KEEP FOREVER as the backup will eventually age out of the control file
I think BDE only keep forever option require recovery catalog
sure of BDE, D is correct "The log backup contains just those archived logs needed to restore this backup to a consistent state"
correct
BDE - assuming Archival is the KEEP criteria. A, C, F, G definitely incorrect.
BDE correct
BCE FG wrong - tested in stend E not exist ARCHIVAL attribute see about C https://www.examtopics.com/discussions/oracle/view/23424-exam-1z0-083-topic-1-question-79-discussion/
RMAN-03002: failure of backup command at 01/19/2022 21:54:57 ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
BDE NOT C using channel ORA_DISK_1 backup will be obsolete on date 28.02.2022 21:54:56
i took yesterday the exam, correct answers are BDE (there is "ARCHIVAL attribute" in the exam too)