Recovering Databases with RMAN - OCP: Oracle Database 12c Administrator Certified Professional - page 235

10. You need to restore your database to 9/30/2013 at 18:00. In what order would you run
the following commands to compete this task?
a. RESTORE CONTROLFILE UNTIL TIME'09/30/2013:18:00:00';
b. RESTORE DATABASE UNTIL TIME'09/30/2013:18:00:00';
c. RESTORE SPFILE UNTIL TIME'09/30/2013:18:00:00';;
d. RECOVER DATABASE UNTIL TIME'09/30/2013:18:00:00';
e. ALTER DATABASE OPEN RESETLOGS;
f. ALTER DATABASE OPEN;
A. b, d, e
B. b, d, f
C. c, a, b, d, e
D. c, a, b, d, f
E. a, b, d, e
11. What is the correct order of the following commands if you wanted to restore data
file 4, which was accidentally removed from the file system?
a. SQ; 'ALTER DATABASE DATAFILE 4 ONLINE';
b. RESTORE DATAFILE 4;
c. RECOVER DATAFILE 4;
d. SQL 'ALTER DATABASE DATAFILE 4 OFFLINE';
e. STARTUP
f. SHUTDOWN
A. a, c, b, d
B. d, b, c, a
C. f, d, b, c, a, e
D. c, a, b, d, f
E. a, b, d, e
12. Your database is up and running and one of your three control files is accidentally
erased. You start RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? (Choose all that apply.)
A. The command restores only the missing control file.
B. The command restores all the control files.
C. The command fails because the database is running.
D. This is the correct way to address this problem.
E. This is not the correct way to address this problem.