OCP-1Z0-053-V12.02-663题

663.Which options would you consider while configuring a flash recovery area (fast recovery area in 11g

Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)

A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover

B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the

recovery files created in the flash recovery area

Answer: CD

答案解析：

即如果要配置flash recovery area (fast recovery area in 11gRelease 2)

首先配置两个参数DB_RECOVERY_FILE_DEST和DB_RECOVERY_FILE_DEST_SIZE，指定flash recovery area 的目录以及大小

sys@TEST0924> show parameter recovery

 

NAME                                 TYPE                        VALUE

------------------------------------ -----------             ------------------------------

db_recovery_file_dest                string               /u01/app/oracle/fast_recovery_area

db_recovery_file_dest_size       big integer     4122M

recovery_parallelism                   integer            0

Specifying a Fast Recovery Area

The Fast Recovery Area is a location in which Oracle Database can store and manage files related to backup and recovery. It is distinct from the database area, which is a location for the current database files (data files, control files, and online redo logs).

You specify the Fast Recovery Area with the following initialization parameters:

• DB_RECOVERY_FILE_DEST: Location of the Fast Recovery Area. This can be a directory, file system, or Automatic Storage Management (Oracle ASM) disk group. It cannot be a raw file system.

  In an Oracle Real Application Clusters (Oracle RAC) environment, this location must be on a cluster file system, Oracle ASM disk group, or a shared directory configured through NFS.

• DB_RECOVERY_FILE_DEST_SIZE: Specifies the maximum total bytes to be used by the Fast Recovery Area. This initialization parameter must be specified beforeDB_RECOVERY_FILE_DEST is enabled.

In an Oracle RAC environment, the settings for these two parameters must be the same on all instances.

You cannot enable these parameters if you have set values for the LOG_ARCHIVE_DEST andLOG_ARCHIVE_DUPLEX_DEST parameters. You must disable those parameters before setting up the Fast Recovery Area. You can instead set values for theLOG_ARCHIVE_DEST_n parameters. The LOG_ARCHIVE_DEST_1 parameter is implicitly set to point to the Fast Recovery Area if a local archiving location has not been configured andLOG_ARCHIVE_DEST_1 value has not been set.

Oracle recommends using a Fast Recovery Area, because it can simplify backup and recovery operations for your database.

http://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm#sthref254