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

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:

1. 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.

2. Restores from backup or copies from active database the latest control file that satisfies the UNTIL clause requirements.

3. Mounts the restored or copied backup control file from the active database.

4. Uses the RMAN repository to select the backups for restoring the data files to the auxiliary instance. This step applies to backup-based duplication.

5. Restores and copies the duplicate data files and recovers them with incremental backups and archived redo log files to a noncurrent point in time.

6. Shuts down and restarts the database instance in NOMOUNT mode.

7. Creates a new control file, which then creates and stores the new DBID in the data files.

8. Opens the duplicate database with the RESETLOGS option and creates the online redo log for the new database.