Oracle - 11G - 题库337 - 图文(11)

D. merge Catalog with database E. register database 登记数据库 Answer: E

QUESTION NO: 90

You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message: SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file

?C:\\ORACLE\\PRODUCT\\11.1.0\\DB_1\\DATABASE\\INITORCL.ORA‘ Using

RMAN, how would you respond to this error? 你已经启用了控制文件的自动备份功能。当从 SQL * Plus 启动 你的数据库时，您会收到以下错误消息：SQL> 起动 ORA-01078：故障处理系统参数 LRM-00109：无法打

开参数文件'C：\\ ORACLE\\ PRODUCT\\11.1.0\\ DB_1 的\\ DATABASE\\ INITORCL.ORA 中―使用 RMAN，将

如何回应这个错误呢？

A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt. 发出启动没有挂载命令，然后发出 RMAN 提示符下的从自动备份还原 spfile 命令。

D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

E. Issue the restore spfile from autobackup command from the RMAN prompt. Answer: C

QUESTION NO: 91

While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the

database to a point in time before the corruption? 当工作在一个数据出问题之时，Curt, Bill, Ben 迈克和马特

导入了大量损坏的数据到数据库中。巴勃罗已经发现了这个问题，他需要你将数据库恢复到损坏导入时间点

之前。 2008 年 9 月 6 日下午 6:30 导入了逻辑损坏。下列哪项是正确的命令，用来将数据库恢复到损坏之前 的时间点？

A. restore database until time '06-SEP-2008 06:30:00'); recover database until time '06-SEP-2008 06:30:00'); alter database open;

B. restore database until time '06-SEP-2008 06:30:00'); recover database until time '06-SEP-2008 06:30:00'); alter database open resetlogs;

C. restore database until time '06-SEP-2008 18:29:55'); recover database until time '06-SEP-2008 18:29:55'); alter database open resetlogs; 还原数据库，直到时间'06-九月-2008 18时29分55秒）;恢复数据 库，直到时间2008年9月6日18时29分55秒）;改变数据库打开重置日志; D. restore database until time '06-SEP-2008 18:29:55'); alter database open resetlogs;

E. restore database until time '06-SEP-2008

18:29:55'); recover database;alter database open resetlogs; Answer: C

QUESTION NO: 92

What is the purpose of the until change option of the restore command? 还原命令中的“直到改变”选项的 目的是什么？

A. It allows you to select the SCN that you want to restore to. 它可以让你选择要还原的系统改变号。 B. It allows you to select the log sequence number you want to restore to. C. It allows you to select the timestamp you want to restore to.

D. It allows you to manually stop the restore at any time as online redo logs are applied. E. None of the above. Answer: A

QUESTION NO: 93

What is the purpose of the recover command? (Choose all that apply.) recover 命令的目的是什么？

A. Recover database datafiles from physical disk backup sets. 从物理磁盘的备份集恢复数据库数据文件。 B. Recover required incremental backups from physical disk backup sets. 物理磁盘的备份集恢复所需的增量备份。

C. Recover required archived redo logs from physical disk backup sets. 从物理磁盘的备份集恢复所需的归档重做日志。

D. Apply incremental backups to recover the database. 应用增量备份来恢 复数据库。

E. Apply archived redo logs to recover the database. 应用归档重做日志来 恢复数据库。 Answer: B,C,D,E

QUESTION NO: 94

What is an obsolete backup set? 过时的备份集是什么？

A. A backup set that is missing one or more backup set pieces

B. A backup that has exceeded the retention criteria and is no longer needed 已经超过了保留条件，不再 需要的备份

C. A backup set that does not include archived redo logs D. A backup set that can not be recovered due to corruption E. A backup set superceded by a datafile copy Answer: B

QUESTION NO: 95

What is the purpose of the list expired backup command? 过期备份命令的列表的目的是什 么？ A. Lists all backups impacted by a resetlogs command