【数据恢复】解决ORA-600[4xxx]错误并打开数据库-阿里云开发者社区

开发者社区> 数据库> 正文
登录阅读全文

【数据恢复】解决ORA-600[4xxx]错误并打开数据库

简介:

Recovering a Dropped Table from a Full Database Backup using manual backup and recovery procedures (Doc ID 96197.1) You cannot follow the note exactly as this note is for a valid full backup where you have all logs needed for point in time recovery - the changes you need to make are in the summary steps above. Once you have done the recovery we can attempt a force open (you will have to do the restore/recovery again for sys, sysaux and undo because you have done an open resetlogs on the restored database): YOU ARE ADVISED TO TAKE A FULL COLD OS BACKUP OF THE DATABASE BEFORE PROCEEDING WITH THE FORCE OPEN. To force open a database: 1. if you are using AUM you need to identify ALL rollback segments listed in your dictionary (system dbfs): On unix, you can use the unix strings command to extract the rollback segments: $ strings system01.dbf | grep _SYSSMU | cut -d $ -f 1 | sort -u > listSMU where system01.dbf is the name of the datafile for the SYSTEM tablespace - if you have > 1 system dbf then you need to do this for each file, writing to a different listSMUn file each time. 2. Mount the database and create a pfile (if you dont already have one) SQL>create pfile='init<sid>.ora' from spfile; Edit the pfile - add : _allow_resetlogs_corruption=true undo_management=MANUAL _corrupted_rollback_segments=<list> Where <list> is the list of rollback segment names extracted as above with '$' appended to each name eg _corrupted_rollback_segments=(_SYSSMU1$, _SYSSMU2$........._SYSSMU10$) 3. Remount the instance using the amended pfile and then do the following: SQL>recover database using backup controlfile until cancel; SQL>cancel SQL>alter database open resetlogs; If this works then you can EXPORT the database contents - the database will have to be completely rebuilt and the data re-imported. IF this fails then I need to see the failure (ORA-1555, ORA-600[2662], ORA-600[4194], Ora-600[4000] are common errors raised during force open), along with the alert log extract showing the start up after setting these hidden parameters. Please remember to REMOVE the hidden parameters after you have exported – the should never be used without advice from Oracle Support.



本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1278292

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章
最新文章
相关文章