RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";

RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

RMAN> DUPLICATE TARGET DATABASE TO dup_db

               FROM ACTIVE DATABASE

               PASSWORD FILE

               SECTION SIZE 400M;

Which statement is true about the DUPLICATE command?(choose one)

（含图）

While CDB1 is open,

‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’is accidentally deleted.

To recover from this critical failure, you execute these commands:

（含图）

What will be the outcome?

(Choose two.)

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have different endian formats. 

Examine this list of actions:

1） Make the UNIVERSITY tablespace read-only on the source system.

2） Export the UNIVERSITY tablespace metadata using EXPDP.

3） Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.

4） Copy the UNIVERSITY tablespace data files to the destination system.

5） Copy the Data Pump dump set to the destination system.

6） Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7） Import the UNIVERSITY tablespace metadata using IMPDP.

8） Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

You want to transport the UNIVERSITY tablespace from one database to another.

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have the same endian format. 

Examine this list of steps:.

1） Make the UNIVERSITY tablespace read-only on the source system.

2） Export the UNIVERSITY tablespace metadata using EXPDP.

3） Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause.

4） Copy the cross-platform backup sets to the destination system.

5） Copy the Data Pump dump set from the source to the destination system.

6） Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause.

7） Import the UNIVERSITY tablespace metadata using IMPDP.

8） Make the UNIVERSITY tablespace read/write on the destination system.

Which are the minimum number of steps required, in the correct order, to Transport the UNIVERSITY tablespace?

Which three are true about Data Pump in an Oracle multitenant environment?

Examine this output of an export from the current release of an Oracle

Multitenant database:

$$ sqlplus system/oracle .

SQL> col name for a10

SQL> select name, open_mode from v$$pdbs;

NAME               OPEN_MODE

-----------        ----------------------------

PDB$$SEED         READ ONLY

PDB1                 READ WRITE

PDB2                 MOUNTED

SQL> exit

Next you execute:

$$ expdp system/oracle full=y

What is the outcome?