QUESTION NO: 164
Your database has experienced a loss of datafile users_01.dbf, which is associated with a tablespace
called USERS. The database is still running. Which answer properly describes the order of the steps that
you would use to recover from this error?
a. Shut down the database.
b. Take the users_01.dbf datafile offline with the alter database command.
c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.
d. Restore all users tablespace-related datafiles from backup media.
e. Issue the recover tablespace users command.
f. Issue the recover datafile users_01.dbf command.
g. Start up the database.
h. Bring the users_01.dbf datafile online with the alter database command.
A. a, c, f, g
B. b, c, f, h
C. a, b, c, f, g
D. a, b, c, f, g, h
E. b, c, f, e, g
Answer: B
你的数据库经历了数据文件users_01.dbf的丢失,该文件与一个称为用户的表空间相联系。 该数据库仍在
运行。 哪个答案正确描述用来从错误中恢复的步骤顺序?
B. b, c, f, h
b.用改变数据库命令使users_01.dbf的数据文件脱机。
c.用所需的归档重做日志从备份介质还原users_01.dbf数据文件。
f.发出恢复数据文件users_01.dbf命令。
h.用改变数据库命令使users_01.dbf数据文件在线。