OCP-1Z0-052-V8.02-70题

Oracle数据库在ARCHIVELOG模式下使用Flash Recovery Area (FRA)。FRA的存储管理由备份保留策略控制,自动删除过时的闪回日志和不再需要的备份以释放空间。保留策略可以基于备份的冗余或恢复窗口。即使文件过时,通常也不会立即删除,除非需要为新文件腾出空间。FRA是便捷的归档目的地,自动删除过时文件并移至磁带。

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

70. You configured the Flash Recovery Area (FRA) for your database. The database instance is running

in ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.

Which two files are removed automatically if the space is required in the FRA as per the retention policy?

(Choose two.)

A.flashback log files 

B.backups that have become obsolete 

C.copies of the data files and control files 

D.archived redo log files that have multiple copies in a different archive location and not backed up

Answer: AB  

答案解析:

参考:http://docs.oracle.com/cd/E11882_01/server.112/e10897/backrest.htm#ADMQS12218



分配给快速恢复区的磁盘空间量取决于数据库的大小和活动级别。通常情况下,快速恢复

区越大,就越有用。理想情况下,快速恢复区应足够大,可存放数据文件和控制文件副本,

以及基于保留策略从保留的备份恢复数据库所需的闪回日志、联机重做日志和归档日志。

(简而言之,快速恢复区至少应为数据库大小的两倍,以便可保留一个备份和若干归档

日志。)

快速恢复区的空间管理由备份保留策略控制。保留策略确定文件何时过时,即何时这些文

件对达到数据恢复目标已不再有用。Oracle DB 通过删除不再需要的文件自动管理该存储。


About the Backup Retention Policy and the Fast Recovery Area

Space management in the fast recovery area is governed by a backup retention policy. A retention policy determines when files are obsolete, meaning that they are no longer needed to meet your data recovery objectives.

Retention policies can be based on redundancy of backups or on a recovery window (period of time). When using a policy based on redundancy, the fast recovery area considers a backup of a file obsolete only when the RMAN repository has records of a specified number of more recent backups of that file. When using a recovery policy based on a period of time (or window), you specify a time interval in days. Files are obsolete only when they are no longer needed for complete recovery or point-in-time recovery to a system change number (SCN) within the window. Therefore, a recovery retention policy based on a window is recommended.

Even after files in the fast recovery area are obsolete, they are typically not deleted until space is needed for new files. If space permits, files recently moved to tape remain on disk to avoid restoring them from tape for a recovery. The automatic deletion of obsolete files and files moved to tape from the fast recovery area makes it a convenient archiving destination. Other destinations require manual deletion of logs.



  1. Select Enable Flashback Database.

    This option specifies that the database should generate flashback logs in the fast recovery area, enabling you to use Flashback Database. During usual operation, the database occasionally logs images of data blocks to the flashback logs. The database automatically creates, deletes, and resizes flashback logs.

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值