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:oracleoradata eworclcontrol01.ctl',
'c:oracleoradata eworclcontrol02.ctl' set db_file_name_convert 'c:oracleoradataorcl','
c:oracleoradata eworcl' set log_file_name_convert 'c:oracleoradataorcl','c:oracleoradata eworcl';
B. Set oracle_sid=orcl
rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database nofilenamecheck spfile set
control_files
'c:oracleoradata eworclcontrol01.ctl', 'c:oracleoradata eworclcontrol02.ctl' set
db_file_name_convert
'c:oracleoradataorcl','c:oracleoradata eworcl' set log_file_name_convert
'c:oracleoradataorcl','c:oracleoradata eworcl';
C. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database to
neworcl nofilenamecheck spfile set control_files 'c:oracleoradata eworclcontrol01.ctl',
'c:oracleoradata eworclcontrol02.ctl' set db_file_name_convert 'c:oracleoradataorcl','
c:oracleoradata eworcl' set log_file_name_convert 'c:oracleoradataorcl','c:oracleoradata eworcl';
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:oracleoradata eworclcontrol01.ctl',
'c:oracleoradata eworclcontrol02.ctl' set db_file_name_convert 'c:oracleoradataorcl','
c:oracleoradata eworcl' set log_file_name_convert 'c:oracleoradataorcl','c:oracleoradata eworcl';
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:oracleoradata eworclcontrol01.ctl',
'c:oracleoradata eworclcontrol02.ctl' set db_file_name_convert 'c:oracleoradataorcl','
c:oracleoradata eworcl' set log_file_name_convert 'c:oracleoradataorcl','c:oracleoradata eworcl';
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，正确。
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)