OCP-1Z0-053-V13.02-700题

最新推荐文章于 2021-06-26 09:10:20 发布

原创最新推荐文章于 2021-06-26 09:10:20 发布 · 7.7k 阅读

0 ·

CC 4.0 BY-SA版权

OCP-1Z0-053 同时被 2 个专栏收录

796 篇文章

订阅专栏

TK Errors

38 篇文章

订阅专栏

本文详细介绍了使用 RMAN 的 DUPLICATE 命令进行数据库复制的过程及注意事项。包括自动创建辅助实例参数文件、恢复控制文件、选择备份文件等关键步骤，并澄清了关于复制数据库 DBID 的常见误解。

700. Which two statements are true about a duplicate database that is created by using the DUPLICATE

command in RMAN? (Choose two.)

A.It is a copy or a subset of the target database.

B.It is opened in RESTRICT mode after a duplicating operation.

C.It is created by using backups and archived redo log files from the target database.

D.It is created with the same database identifier (DBID) as that of target database.

Answer: CD

答案解析：

根据the DUPLICATE command automatically assigns the duplicate database a different DBID D错误。

根据Opens the duplicate database with the RESETLOGS option B错误。

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

所以，正确答案应该为AC

If you copy a database with operating system utilities instead of the DUPLICATE command, then the DBID of the copied database remains the same as the original database. To register the copy database in the same recovery catalog with the original, you must change the DBID with the DBNEWID utility (see Oracle Database Utilities ). In contrast, the DUPLICATE command automatically assigns the duplicate database a different DBID so that it can be registered in the same recovery catalog as the source database.

D错误。

参考： http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#BRADV89928

As part of the duplicating operation, RMAN automates the following steps:

Creates a default server parameter file for the auxiliary instance if the following conditions are true:
- Duplication does not involve a standby database.
- Server parameter files are not being duplicated.
- The auxiliary instance was not started with a server parameter file.
Restores from backup or copies from active database the latest control file that satisfies the UNTIL clause requirements.
Mounts the restored or copied backup control file from the active database.
Uses the RMAN repository to select the backups for restoring the data files to the auxiliary instance. This step applies to backup-based duplication.
Restores and copies the duplicate data files and recovers them with incremental backups and archived redo log files to a noncurrent point in time.
Shuts down and restarts the database instance in NOMOUNT mode.
Creates a new control file, which then creates and stores the new DBID in the data files.
Opens the duplicate database with the RESETLOGS option and creates the online redo log for the new database.