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 password file must exist for the source database and have the same SYS user
password as the target.
B.
The target database backups should be copied to the source database backup
directories.
C.
RMAN should be connected to both the instances as SYSDBA.
D.
The source database should be open.
E.
The target database should be in ARCHIVELOG mode if it is open.