1Z0-050 · Question #20
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…
The correct answer is B. The target database should be in ARCHIVELOG mode if it is open. C. RMAN should be connected to both the instances as SYSDBA. E. The password file must exist for the source database and have the same SYS user password as. See the full explanation below for the reasoning.
Question
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.)
Options
- AThe source database should be open.
- BThe target database should be in ARCHIVELOG mode if it is open.
- CRMAN should be connected to both the instances as SYSDBA.
- DThe target database backups should be copied to the source database backup directories.
- EThe password file must exist for the source database and have the same SYS user password as
How the community answered
(21 responses)- A10% (2)
- B76% (16)
- D14% (3)
Community Discussion
No community discussion yet for this question.