OCP-1Z0-053-V13.02-708题

闪回数据库日志解读

最新推荐文章于 2018-09-30 11:44:54 发布

原创最新推荐文章于 2018-09-30 11:44:54 发布 · 5.6k 阅读

0 ·

CC 4.0 BY-SA版权

OCP11g解析同时被 2 个专栏收录

870 篇文章

订阅专栏

OCP-1Z0-053

796 篇文章

订阅专栏

本文探讨了通过V$FLASHBACK_DATABASE_LOG视图获取的信息，包括数据库可闪回至的时间和最低系统更改号(SCN)，有助于评估当前工作负载所需的闪回空间大小。

708. You executed the following query:

Considering that all the redo logs are available, what information can you derive from the output of the

preceding query?

A.The time when the last flashback operation in your database was performed

B.The time when the first flashback operation in your database was performed

C.The approximate time and the lowest system change number (SCN) to which you can flashback your database

D.The system change number (SCN) and the time when the Flashback Database was enabled in the

database instance

Answer: C

答案解析：

题中问：考虑到所有的重做日志可用，什么样的信息可以来自上述查询的输出？

V$FLASHBACK_DATABASE_LOG

V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.

Column	Datatype	Description
`OLDEST_FLASHBACK_SCN`	`NUMBER`	Lowest system change number (SCN) in the flashback data, for any incarnation
`OLDEST_FLASHBACK_TIME`	`DATE`	Time of the lowest SCN in the flashback data, for any incarnation
`RETENTION_TARGET`	`NUMBER`	Target retention time (in minutes)
`FLASHBACK_SIZE`	`NUMBER`	Current size (in bytes) of the flashback data
`ESTIMATED_FLASHBACK_SIZE`	`NUMBER`	Estimated size of flashback data needed for the current target retention