Performing Oracle User-Managed Database Recoveries - OCP: Oracle Database 12c Administrator Certified Professional - page 99

Variable Size 146804528 bytes
Database Buffers 20971520 bytes
Redo Buffers 2506752 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01.log'
ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01a.log'
You can choose from the following steps:
1. Restore the database data files.
2. Issue the ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP command.
3. Issue the ALTER DATABASE OPEN command.
4. Issue the ALTER DATABASE OPEN RESETLOGS command.
5. Recover the database using point-in-time recovery.
6. Issue the STARTUP MOUNT command to mount the database.
7. Back up the database.
Which is the correct order of these steps in this case?
A. 1,6,5,4,7
B. 6,5,4
C. 6,2,3,7
D. 1,6,3
E. The database cannot be recovered.
11. A user sends you an email with the following error message:
create table idtable(id number)
*
ERROR at line 1:
ORA-01116: error in opening database file 4
ORA-01110: data file 4: '/oracle01/oradata/orcl/users01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
You can choose from the following steps:
1. Restore the missing database data file.
2. Take the missing data file offline.
3. Shut down the database.