1Z0-083 practice question 21 of 35
Choose the best. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?
Full set: 286 questionsThe recovery window is configured for five days. With the current date being August 26th, the database must be recoverable to any point in time between August 21st (26th minus 5 days) and the present. To recover to August 21st, RMAN requires the most recent level 0 backup taken on or before that date, which is the backup from August 17th. All subsequent level 1 incremental backups are also needed. Therefore, the level 0 backup from August 17th is the earliest backup that must be retained. All backups created prior to August 17th are no longer necessary to satisfy the five-day recovery window and are considered obsolete.
A. This is incorrect because the level 0 backup from August 10th is also obsolete, as it's before the required backup of August 17th.
B. This is incorrect. Backups from August 17th through August 21st are essential to satisfy the recovery window.
C. This is incorrect. Backups from August 17th, 18th, and 19th are required to recover to points within the recovery window.
D. This is incorrect. Many backups before the 24th are required, starting with the level 0 backup from the 17th.
1. Oracle Database Backup and Recovery User's Guide 19c, "Configuring the Recovery Window". It states, "RMAN retains all backups required to recover the database to any point in time during the window."
2. Oracle Database Backup and Recovery User's Guide 19c, "How RMAN Determines Obsolescence". The guide explains that a backup is obsolete if it is not needed to recover to a point in time within the recovery window. In this scenario, the point of recoverability starts on Aug 21st, making the Aug 17th backup essential.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
