非归档模式表空间坏 如何恢复
非归档模式表空间坏 如何恢复(without losing new data in the other tablespaces)
source problem:You have found corruption in a tablespace that contains static tables that are part of a
database that is in NOARCHIVE log mode. How would you restore the tablespace
without losing new data in the other tablespaces?
------解决方案--------------------offline
------解决方案--------------------这样就可满足题目要求,不影响别的表空间。
然后offline后,alter database create datafile x;来重建该表空间下受损数据文件。
之后运气好的话做个media recover还能完全恢复。
------解决方案--------------------你试着用recovery看能不能恢复。。。