1. 首页
  2. IT资讯

alter database force open with _ALLOW_RESETLOGS_CORRUPTION = TRUE

http://203.208.39.132/search?q=cache:0W30-f-vGR0J:www.experts-exchange.com/Database/Oracle/Product_Info/Q_20643126.html+Oracle+_allow_resetlogs_corruption&cd=5&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_LW_AVy-icVpOxO7QQE_ItfJrYew[@more@]

This is a two-part question.I have a partially restored database where I have some new, and some older datafiles. Together I have them all. No archivelogs, no anything. This is the path I must take!I have to do a force open of the database with _ALLOW_RESETLOGS_CORRUPTION = TRUEThis is ok, and I will have a inconsistent database afterwards. However, there is not much data added in the database between the datafiles I have, perhaps nothing if I am real lucky. Is it possible to make this inconsistent database consistent in some way afterwards, and then go through the database and check for concistency errors (added data in some tables and then remove it etc.)If not, I have to export all tables, rebuild the database, import tables and rebuild indexes. This is a rather complex database with lots of users/stored procedures/views etc. so the rebuild will take for ages. Any short-cuts that can be taken here, for instance exporting out the build of the database in script format or something from the corrupt database?This is urgent as the dabase is a production database and is down for the moment.Thanks,Morten

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027491/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194712.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code