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 ‘/oracIe/oradata/prod/1,
‘/scratch/oracIe/oradata/dupdb/1
SPILE
PARAMETER_VALUE_CONVERT’/oracle/oradata/prod/1,
‘/scratch/oracIe/oradata/dupdb/1
SET SGA_MAX_SIZE = ‘300M1
SET SGA_TARGET = ‘250M’
SET LOG_FILE_NAME_CONVERT ‘/oracle/oradata/prod/redo/’,
‘/scratch/oracIe/oradata/dupdb/redo/1;
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.
Hello, correct answers – B, C, E.
The correct is A, C, E.
The B option refers to the target database.