75.Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten
since the last backup.
What would you do to recover the data file?
A.Take the USERS tablespace offline and re-create the lost data file.
B.Shut down the instance, restore the data file from the last consistent backup, and restart the database instance.
C.Shut down the instance, restore all the database files from the last consistent backup, and restart the database instance.
D.Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup, and make the tablespace online.
答案:C
解析:数据库运行在非归档模式下,user表空间的数据文件损坏了,怎么处理
这里由于运行在非归档模式下,所以只能进行冷备,恢复的话只能将所有的数据文件,控制文件,重做日志文件,参数文件以及密码文件
全部进行替换,然后启动,因此只能选择C,注意其实不光是所有数据文件,最起码还需要控制文件和重做日志文件
tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten
since the last backup.
What would you do to recover the data file?
A.Take the USERS tablespace offline and re-create the lost data file.
B.Shut down the instance, restore the data file from the last consistent backup, and restart the database instance.
C.Shut down the instance, restore all the database files from the last consistent backup, and restart the database instance.
D.Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup, and make the tablespace online.
答案:C
解析:数据库运行在非归档模式下,user表空间的数据文件损坏了,怎么处理
这里由于运行在非归档模式下,所以只能进行冷备,恢复的话只能将所有的数据文件,控制文件,重做日志文件,参数文件以及密码文件
全部进行替换,然后启动,因此只能选择C,注意其实不光是所有数据文件,最起码还需要控制文件和重做日志文件