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:
a: Restore the missing database datafiles.
b: Take the missing datafile offline.
c: Shut down the database.
d: Issue the recover tablespace USERS command.
e: Issue the Startup Mount command to mount the database.
f: Bring the USERS tablespace online.
g: Issue the alter database open command.
Which is the correct order of these steps in this case?
A.
b, a, d, f
B.
c, a, e, b, d, f, g
C.
c, e, d, g
D.
b, d, f
E.
e, d, g
Explanation:
RMAN> repair failure;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/test0924/test0924/hm/reco_172511374.hm
contents of repair script:
# restore and recover datafile
sql ‘alter database datafile4 offline’;
restore datafile 4;
recover datafile 4;
sql ‘alter database datafile 4 online’;