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_CORRUPTIO
This 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
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_CORRUPTIO
This 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博客 ” ，链接：https://blog.itpub.net/450962/viewspace-1027491/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
scn号与恢复研究
请登录后发表评论
登录
全部评论
