OCP 053 102-106-CSDN博客

QUESTION 102

A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.?A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash.

The steps to recover from the loss of a current redo log group member in the random order are as follow.

1) Restore the corrupted redo log group.?

2) Restore from a whole database backup.?

3) Perform incomplete recovery.?

4) Relocate by renaming the member of the damaged online redo log group to a new location.

5) Open the database with the RESETLOGS option.

6) Restart the database instance.

7) Issue a checkpoint and clear the log.

Identify the option with the correct sequential steps to accomplish the task efficiently.

A．1，3，4，and 5

B．7，3，4，and 5

C．2，3，4，and 5

D．7，4，3，and 5

E．Only 6 is required

Answer：B

Explanation

【题目示意】

此题考查有关于在线日志组恢复的知识

【解析】

数据库实例crash后，正确的恢复顺序是为先检查点并且清空日志，执行不完全恢复，把被损坏的在线日志组迁移到新的位置并重新命名，之后以清空日志的形式打开数据库，至此，数据库恢复过程完成。

【小结】选择B

QUESTION 103

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN). (Choose two.)

A.You can use RMAN stored scripts.

B.Recovery is faster if data is stored in catalog in addition to the control file.

C.You can store backup Information of all registered databases in one place.

D.Database backups are automatically deleted when they are older than the specified time period.

Answer: AC

Explanation

【题目示意】

此题考查有关于RMAN、恢复目录的知识。

选择两个使用RMAN恢复目录备份控制文件到目标数据库的最有代表性的优点。

【解析】

RMAN的优点有：1、即使数据库的控制文件丢失了，也可以通过RMAN本身存储的脚本来执行控制文件的恢复。2、你可以把数据库所有的备份信息存储到一个地方。

RMAN 资料档案库数据始终存储在目标数据库的控制文件中。此外，它也可以存储在一个名为“恢复目录”的单独数据库中。

恢复目录会在单独的数据库中保留备份信息，这在控制文件丢失时尤为有用。这样你可以存储更长的备份历史记录，比基于控制文件的资料档案库所存储的历史记录还要长。使用一个恢复目录可存储多个目标数据库的信息。恢复目录还可用来存放RMAN 存储脚本，这些脚本是RMAN命令的序列。

如果你的备份管理要求很简单，则Oracle建议你使用控制文件选项而不要使用恢复目录。拥有恢复目录意味着你需要管理并备份其它数据库。因此，只有在可利用恢复目录所提供的优点（如较长的备份保留时间）时，才使用恢复目录。

【小结】选择AC

相关参考：http://blog.csdn.net/rlhua/article/details/13277925

QUESTION 104

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional.

You could consider performing the following steps to accomplish this task:

1) Restore an autobackup of the server parameter file.

2) Restore the control file.

3) Start the target database Instance.

4) Mount the database.

5) Restore the data files.

6) Open the database with the RESETLOGS option.

7) Recover the data files.

8) Set DBID for the target database

Which option illustrates the correct sequence that you must use?

A.8, 1, 3, 2, 4, 5, 7, 6

B.1, 8, 3, 4, 2, 5, 7, 6

C.1, 3, 4, 2, 8, 5, 6, 7

D.1, 3, 2, 4, 6, 5, 7, 8

Answer: B

Explanation

【题目示意】

此题考查有关于数据库备份恢复的知识。

你正在使用RMAN的恢复目录备份你的生产库。备份和归档重做日志文件被复制到一个磁带上。由于介质故障，你的生产库连同目标库的数据一起丢失了，现在需要把目标数据库恢复并且使其发生作用。

【解析】

首先应该恢复自动备份的服务器参数文件，设置目标库的DBID使它和原生产库相同。开启目标库的数据库实例，启动到mount阶段，恢复控制文件，恢复数据文件，还原数据文件，以清空日志的方式打开数据库

【小结】选择B

QUESTION 105

You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.?What must you set using the RMAN CONFIGURE command to achieve this?

A. MAXSETSIZE TO 2;

B. DEVICE TYPE DISK PARALLELISM 2;

C. RETENTION POLICY TO REDUNDANCY 2;

D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Answer: C

Explanation

【题目示意】

此题考查有关于RMAN备份的知识。

一个用磁盘RMAN备份做默认备份配置的数据库，因商业需求，你需要同时重复备份数据文件。在你使用RMAN的configure时什么参数是你必须要设置的？

【解析】

此题选C，RMAN备份的保留策略是必须要配置的。为每个数据文件保留2个冗余备份（默认值为1）。

冗余保留策：如果需要保留一定数量的备份，可以通过冗余选项设置保留策略。此选项要求在任何备份被标识为过时之前将指定数量的备份列入目录。默认保留策略的冗余度为1，这表示在任意指定时间一个文件只存在一个备份。当同一文件的最新版本已经有备份时，上一个备份就被视为过时。

【小结】选择C

相关参考：http://blog.csdn.net/rlhua/article/details/12361883

QUESTION 106

Examine the following ALTER command;

SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

What is the purpose of the command?

A. It cancels all pending disk drops within the disk group.

B. It adds previously dropped disks back into the disk group.

C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

D. It mounts disks in the disk group for which the drop-disk operation has already been completed.

E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.

Answer: A

Explanation

【题目示意】

此题考查有关于alter diskgroup命令相关的知识。

【解析】

取消磁盘组中所有有待删除的磁盘。

undrop_disk_clause

Use this clause to cancel the drop of disks from the disk group. You can cancel the pending drop of all the disks in one or more disk groups (by specifyingdiskgroup_name) or of all the disks in all disk groups (by specifying ALL).

This clause is not relevant for disks that have already been completely dropped from the disk group or for disk groups that have been completely dropped. This clause results in a long-running operation. You can see the status of the operation by querying the V$ASM_OPERATION dynamic performance view.

【小结】选择A