Which is the correct order of these steps in this case?

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 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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


vasya_pupkin

vasya_pupkin

where is open database?