QUESTION NO: 398
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/’ SPFILE
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.
Answer: B,C,E
作为一个DBA,您正在管理APPPROD数据库。您计划复制此数据库与命名为
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/’ SPFILE
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.目标数据库必须在归档记录模式下,如果它是打开的。
C.RMAN应以SYSDBA身份连接到两个实例。
E.用于源数据库的密码文件必须存在且和目标数据库具有相同的SYS用户密码。