17題、Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.

Examine the steps to recover this table from an RMAN backup:

1. Determine which backup contains the table that needs to be recovered.

2. Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.

3. Import the Data Pump export dump file into the auxiliary instance.

4. Create a Data Pump export dump file that contains the recovered table on a target database.

Identify the required steps in the correct order.

A. 1, 4,3

B. 1, 2

C. 1, 4, 3,2

D. 1, 2, 4

Answer: B

Explanation:(可以在表 recovery 的時(shí)候指定導(dǎo)出什么表，同時(shí)導(dǎo)入到目標(biāo)數(shù)據(jù)庫(kù)，所以無(wú)需手動(dòng)的導(dǎo)出和導(dǎo)入

RMAN>

RECOVER TABLE HR.PDB_EMP OF PLUGGABLE DATABASE pdbprod1 UNTIL SEQUENCE 76

AUXILIARY DESTINATION '/u03/res/'

DATAPUMP DESTINATION '/u03/dmp/'

REMAP TABLE 'HR'.'PDB_EMP':'EMP_RECVR';

注意，把 hr 的 pdb_emp 表導(dǎo)出來(lái)后再導(dǎo)入，同時(shí)改名 emp_recvr。)