Oracle OCP 19c 认证1Z0-083考试(第71-80题) - #宝，输了液

 

 

Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage.

Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command:

RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;

What is a prerequisite for the successful execution of this command

A)    RMAN must be connected to the target database instance and the auxiliary instance.

B)    A most recent backup set of the PROD database must exist. C) Flashback must be enabled for the PROD database.

D) The target database must be in MOUNT state.

Answer:A

(解析:由于是用 ACTIVEDATABASE 复制数据库,所以必须要连接目标数据库和辅助实例; 如果不是 ACTIVE DATABASE 复制方式,可以不需要连接目标数据库以及 catalog 数据库。) RMAN 通过网络(active 方式)在新节点上复制数据库 新节点要求如下:
l 数据库名同 source database

l 实例名同 source database(可以不一样)

l 数据库(控制文件,在线日志,数据文件)目录:同 source database,可以不一样,

在初 始化参数文件中指定数据文件的转换。

l 目标数据库和复制数据库的密码文件的密码必须一样 l 连接到目标数据库和辅助数据库,必
 
须要用 sys 用户连接,不能用 target /方式连接,

且源数据库和目标数据库的 tnsnames 文件中包含各自的连接别名(如果使用备份进行 复制, 比如使用 SECTION SIZE 参数进行复制)

31、A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week.
Examine this command, which will be executed in CDB1:

CREATE PLUGGABLE DATABASE pdb1

USING    ‘/u01/app/oracle/oradata/pdb1.xml’    SOURCE_FILE_NAME_CONVERT    = (‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);
Which two are true? (Choose two.)

A.    PDB1 data files already exist in the correct location.

B.    DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
C.    PDB_FILE_NAME_CONVERT must be set before executing the command.

D.    /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1. E. PDB1 must be dropped from CDB1.
Answer: AE(40 道)

(解析:目标数据文件