98 Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - Th

最新推荐文章于 2022-05-24 15:20:02 发布

EVISWANG

最新推荐文章于 2022-05-24 15:20:02 发布

阅读量1k

点赞数

分类专栏： OCP 053

本文链接：https://blog.youkuaiyun.com/EVISWANG/article/details/50061581

版权

OCP 053 专栏收录该内容

86 篇文章

订阅专栏

本文通过具体场景分析了数据库备份优化在RMAN配置下如何运作，特别是当TOOLs表空间在读取只状态时，在设定的恢复窗口内进行备份的操作逻辑。讨论了在特定条件下备份是否会失败、被跳过，还是正常执行，强调了恢复窗口对于备份决策的影响。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

98
Consider the following scenario for your database:
- Backup optimization is enabled in RMAN.
- The recovery window is set to 7 days in RMAN.
- The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
- The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk.
Which statement is true regarding the backup of the TOOLS tablespace?
A. The RMAN backup fails because the TOOLS tablespace is read-only
B. The RMAN skips the backup of the tablespace because backup optimization is enabled
C. The RMAN makes backup because optimization can be enabled only for backups to disk
D. The RMAN makes the backup because no backup of the tablespace exists within the seven day

window

Correct Answer: D
Section: (none)

Explanation

Explanation/Reference:
Explanation:
http://web.njit.edu/info/limpid/DOC/backup.102/b14191/rcmconc1008.htm
With a recovery window-based retention policy:
For backups to tape, RMAN takes another backup of a file, even if a backup of an identical file exists, if the
most recent backup is older than the configured recovery window. This is done to allow media to be
recycled after the media expires.
For backups to disk, RMAN skips taking the backup if an identical file is available from a backup on disk,
even if that backup is older than the beginning of the recovery window. The retention policy causes RMAN
to retain the old backup for as long as it is needed.