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

 

356.Which of the following commands will perform an active database duplication of the ORCL database

to the ORCL2 database?

A. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 create duplicate target

database to neworcl from active database nofilenamecheck spfile set control_files '

c:\oracle\oradata\neworcl\control01.ctl',

'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','

c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';

B. Set oracle_sid=orcl

rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database nofilenamecheck spfile set

control_files

'c:\oracle\oradata\neworcl\control01.ctl', 'c:\oracle\oradata\neworcl\control02.ctl' set

db_file_name_convert

'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' set log_file_name_convert

'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';

C. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database to

neworcl nofilenamecheck spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl',

'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','

c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';

D. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert duplicate target database to neworcl

from active database nofilenamecheck spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl',

'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','

c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';

E. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database to

neworcl from active database nofilenamecheck spfile set control_files

'c:\oracle\oradata\neworcl\control01.ctl',

'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','

c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';

Answer: E

答案解析：

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

官方参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF90171

A，create duplicate target database to neworcl from active database ，此处多了create。

B，duplicate target database，此处缺少to neworcl from active database

C，缺少 from active database。

D，auxname=sys/Robert ，此处缺少@orcl2。

E，正确。

For active database duplication, you must connect to the source database as  TARGET   and to the auxiliary instance as  AUXILIARY . You must use the same  SYSDBA  password for both instances and must supply the net service name to connect to the  AUXILIARY  instance. A recovery catalog connection is optional.

Example 24-1 Duplicating to a Host with the Same Directory Structure (Active)

DUPLICATE TARGET DATABASE TO dupdb

  FROM ACTIVE DATABASE

  PASSWORD FILE

  SPFILE

  NOFILENAMECHECK;

指定下列参数来显式控制辅助数据库的文件命名：

• CONTROL_FILES

• DB_FILE_NAME_CONVERT

•  LOG_FILE_NAME_CONVERT

CONTROL_FILES='/u01/app/oracle/oradata/aux/control01.ctl',

'/u01/app/oracle/oradata/aux/control02.ctl',

'/u01/app/oracle/oradata/aux/control03.ctl'

DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl',

'/u01/app/oracle/oradata/aux'

LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl',

'/u01/app/oracle/oradata/aux'