You have configured RMAN SBT channels to write backups to media. You then take an RMAN backup by using this command: Which three are true? (Choose three.)
A.
The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
B.
The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
C.
All archive logs created after this backup are kept for two years.
D.
The SPFILE is included in the self-contained archival backup.
E.
The control file is included in the self-contained archival backup.
F.
The restore point is a label for the system change number (SCN) before the archival backup was taken.
B,D,E are correct
The restore point is a label for the SCN to which this archival backup can be restored and recovered , and is captured just after the data file backups complete. (F is wrong)
Normal restore points are retained in the database for at least the number of days specified for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter (A incorrect)
-The control file autobackup that RMAN automatically makes when you use the backup .. keep command has a copy of the restore point (and also the spfile D and E are correct)
KEEP - Specifies the backup as an archival backup, which is a self-contained backup that is exempt from the configured retention policy.
UNTIL TIME - Specifies the time until which the backup or copy must be kept (B correct)
https://docs.oracle.com/cd/E18283_01/server.112/e17118/statements_6011.htm
http://devel.hotpilot.cz/ora11gR2u2-full/backup.112/e10643/rcmsubcl011.htm
An example:
http://www.online-database.eu/recovery-manager-rman/143-rman-backupsets-with-restore-point
It supports an optional RESTORE POINT clause that creates a normal restore point, which is a label for an SCN to which the backup must be recovered to be made consistent. The SCN is captured just after the data file backups complete. RMAN resynchronizes restore points with the recovery catalog and maintains the restore points as long as the backup exists. "Listing Restore Points" explains how to display restore points.
ok it's a small difference, archival backup = datafile & archivelog. restore point is jus tafter the datafile backup ready. will be followed by archivelog, cf, spfile
Why NOT A & F:
NOT A - normal restore point can age out of the control file (only guaranteed restore point never expire), see Oracle Doc: "7.1.5 About Guaranteed Restore Points
Like a normal restore point, a guaranteed restore point serves as an alias for an SCN in recovery operations. A principal difference is that guaranteed restore points never age out of the control file and must be explicitly dropped."
NOT F - not before, but after: see Oracle Doc: "RESTORE POINT restore_point_name - Creates a normal restore point matching the SCN to which RMAN must recover the backup to a consistent state, restore point name must not already exist, The SCN is captured just AFTER the data file backups COMPLETE."
BDE as explained here: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html#GUID-09DA2028-0C54-492B-BDE9-9CE07BCD4390
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-083 Exam Questions
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.
veginha
Highly Voted 3 years, 10 months agojanw
3 years, 8 months agojanw
3 years, 8 months ago1451755
Most Recent 2 weeks, 5 days agoGuhborges
9 months, 3 weeks ago_gio_
10 months, 3 weeks ago