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

87. You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash

Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the

alert log file:

ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0

remaining bytes available.

What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)

A.Back up the Flash Recovery Area.

B.Decrease the retention time for the database backup and flashback log files.

C.Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS)

commands. D.Manually delete all the expired backup sets from the Flash Recovery Area by using operating system

(OS) commands.

Answer: AB  

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12306189

参考：指定保留策略：http://blog.csdn.net/rlhua/article/details/12308231

 

 

当快速恢复区的已用空间达到85% 时，会发出警告；当已用空间达到97% 时，会发出严重警告。这些都是内部设置，无法更改。

以下是一个预警日志输出示例：

WARNING: db_recovery_file_dest_size of 52428800 bytes is

100.00% used, and has 0 remaining bytes available.

 

可以发出以下查询来确定要执行的操作：

SQL> SELECT object_type, message_type, message_level,

2 reason, suggested_action

3 FROM dba_outstanding_alerts;

 

可以选择增加额外的磁盘空间、将文件备份到三级存储设备、使用RMAN 从快速恢复区删除文件或考虑更改RMAN 保留策略。

Setting the DB_RECOVERY_FILE_DEST Parameter

Include the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters in your initialization parameter file to identify the default location for the Fast Recovery Area. The Fast Recovery Area contains:

• Redo log files or multiplexed copies of redo log files

• Control files or multiplexed copies of control files

• RMAN backups (data file copies, control file copies, backup pieces, control file autobackups)

• Archived logs

• Flashback logs

You specify the name of file system directory that becomes the default location for creation of the operating system files for these entities. For example:

DB_RECOVERY_FILE_DEST = '/u01/app/oracle/fast_recovery_area'

DB_RECOVERY_FILE_DEST_SIZE = 20G