ocp-v13-497

QUESTION 497
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the
same system with the name DUPDB. You issued the following RMAN commands to create a duplicate
database:

RMAN> CONNECT target sys/sys@APPPROD
RMAN> DUPLICATE TARGET DATABASE TO dupdb 
FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT 
'/oracle/oradata/prod/',
'/scratch/oracle/oradata/dupdb/' 
SPILE PARAMETER_VALUE_CONVERT
'/oracle/oradata/prod/', 
'/scratch/oracle/oradata/dupdb/' 
SET SGA_MAX_SIZE = '300M' 
SET SGA_TARGET = '250M' 
SET LOG_FILE_NAME_CONVERT
'/oracle/oradata/prod/redo/',
'/scratch/oracle/oradata/dupdb/redo/';

Which three are the prerequisites for the successful execution of the above command? (Choose three.)

A. The source database should be open.

B. The target database should be in ARCHIVELOG mode if it is open.

C. RMAN should be connected to both the instances as SYSDBA.

D. The target database backups should be copied to the source database backup directories.

E. The password file must exist for the source database and have the same SYS user password as the target.

Correct Answer: BCE

---

你是管理appprod数据库DBA。你打算在这个数据库中复制这个数据库
这个名字dupdb系统。你写了如下的RMAN命令来创建一个副本数据库：

RMAN> CONNECT target sys/sys@APPPROD
RMAN> DUPLICATE TARGET DATABASE TO dupdb 
FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT 
'/oracle/oradata/prod/',
'/scratch/oracle/oradata/dupdb/' 
SPILE PARAMETER_VALUE_CONVERT
'/oracle/oradata/prod/', 
'/scratch/oracle/oradata/dupdb/' 
SET SGA_MAX_SIZE = '300M' 
SET SGA_TARGET = '250M' 
SET LOG_FILE_NAME_CONVERT
'/oracle/oradata/prod/redo/',
'/scratch/oracle/oradata/dupdb/redo/';

其中三个是上述命令的成功执行的先决条件

B.目标数据库应该是在ARCHIVELOG模式。
C.RMAN必须作为SYSDBA权限连接到数据库的实例。
E. 密码文件必须存在于源数据库中，并在目标也具有相同的SYS用户密码

---