超级复杂困难之Oracle数据库大恢复

核心提示： 5.不完全的备份以前的备份机制使得我可以从远程主机找到一系列备份集，但是没有控制文件，超级复杂困难之Oracle数据库大恢复(3)，通过备份集、dbms_backup_restore等手段，首先恢复出来数据文件，搞定UNDO表空间就Ok了Wed Dec 24 21:18:12 2008Er

5.不完全的备份

以前的备份机制使得我可以从远程主机找到一系列备份集，但是没有控制文件。

通过备份集、dbms_backup_restore等手段，首先恢复出来数据文件，然后尝试启动数据库

6.强制打开

通过强制resetlogs手段打开数据库，出现ORA-600 4000错误

　　Wed Dec 24 18:56:00 2008
Errors in file /opt/oracle/admin/stat/udump/stat_ora_21479.trc:
ORA-00600: internal error code, arguments: [4000], [15], [], [], [], [], [], []
Wed Dec 24 18:56:01 2008
Errors in file /opt/oracle/admin/stat/udump/stat_ora_21479.trc:
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00600: internal error code, arguments: [4000], [15], [], [], [], [], [], []

7.通过BBED解决ORA-600 4000错误

这个没说的，只能通过BBED搞定了，修复有问题的数据块，再次尝试打开数据库

8.遇到ORA-600 2662错误

这个错误就好解决了，通过我网站上的示例就可以解决：

　　Wed Dec 24 21:13:17 2008
Errors in file /opt/oracle/admin/stat/udump/stat_ora_28316.trc:
ORA-00600: internal error code, arguments: [2662], [0], [412717646], [0], [412772634], [8389633], [], []
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [0], [412717644], [0], [412772634], [8389633], [], []
Wed Dec 24 21:13:18 2008
Errors in file /opt/oracle/admin/stat/udump/stat_ora_28316.trc:
ORA-00600: internal error code, arguments: [2662], [0], [412717647], [0], [412772634], [8389633], [], []
ORA-00600: internal error code, arguments: [2662], [0], [412717646], [0], [412772634], [8389633], [], []
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [0], [412717644], [0], [412772634], [8389633], [], []
Wed Dec 24 21:13:18 2008
Errors in file /opt/oracle/admin/stat/udump/stat_ora_28316.trc:
ORA-00600: internal error code, arguments: [2662], [0], [412717647], [0], [412772634], [8389633], [], []
ORA-00600: internal error code, arguments: [2662], [0], [412717646], [0], [412772634], [8389633], [], []
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [0], [412717644], [0], [412772634], [8389633], [], []

9.解决ORA-600 4097号错误

接下来继续出现ORA-600 4097号错误，这个也好解决，搞定UNDO表空间就Ok了

　　Wed Dec 24 21:18:12 2008
Errors in file /opt/oracle/admin/stat/bdump/stat_j000_28723.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []

10.解决一些其他小问题

此处省略10000字，终于搞定了用户数据库！

这个案例所用到的所有知识在我的网站上全都有详细介绍，不过要能把所有知识综合运用才能解决这次的故障。