QUESTION 165-RESTORE PLUGGABLE/RECOVER PLUGGABLE

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and  PDB2_2, is running in ARCHIEVELOG mode. An RMAN backup exists for the databases.

You issue the following commands and get an error:

$ sqlplus / as ssdba

SQL> CONNECT system/oracle_4U@PDB2_1

SQL> SELECT * FROM mydata;

select * from mydate

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL Level 1

ORA-01116: error in opening database file 8

ORA-01110: data file 8:

'/u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf'

ORA-27041: unable to open file

Examine the following commands:

1. SHUTDOWN ABORT

2. STARTUP MOUNT

3. RESTORE TABLESPACE pdb2_1:SYSTEM;

4. RECOVER TABLESPACE pdb2_1:SYSTEM;

5. RESTORE PLUGGABLE DATABASE pdb2_1;

6. RECOVER PLUGGABLE DATABASE pdb2_1;

7. ALTER DATABASE OPEN;

8. ALTER PLUGGABLE DATABASE ALL OPEN;

9. ALTER DATABASE OPEN RESETLOGS;

10. ALTER PLUGGABLE DATABASE pdb2_1 CLOSE IMMEDIATE;

Identify two correct sequences of commands to perform a recovery and make the data available.

A. 1,2,3,4,7,8

B. 1,2,5,6,7,8

C. 1,2,10,5,6,9

D. 10,3,4,8,9

 

 

 

 

Correct Answer: BC