请高手指点一下，服务器突然断电，oracle数据库登录不了

[忆尘]

数据库登录的时候报错：
ora-01034 oracle not available
ora-27101 shared memory realm does not exist
从网上找到的方法试了
sqlplus /nolog
connect / as sysdba
startup
可是还是不行，启动是成功了，然后过一会就会报

alert里面文字太多，黏贴一部分内容，如果有需要继续传，高手帮帮忙哈，着急~~~
Mon Jul 29 10:16:46 2013
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Jul 29 10:16:46 2013
ALTER DATABASE OPEN
Mon Jul 29 10:16:47 2013
Beginning crash recovery of 1 threads
Mon Jul 29 10:16:47 2013
Started first pass scan
Mon Jul 29 10:16:47 2013
Completed first pass scan
2 redo blocks read, 0 data blocks need recovery
Mon Jul 29 10:16:47 2013
Started recovery at
Thread 1: logseq 297, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 297 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO02.LOG
Mon Jul 29 10:16:47 2013
Ended recovery at
Thread 1: logseq 297, block 5, scn 0.58690729
0 data blocks read, 0 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Mon Jul 29 10:16:47 2013
Thread 1 advanced to log sequence 298
Thread 1 opened at log sequence 298
Current log# 3 seq# 298 mem# 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Successful open of redo thread 1.
Mon Jul 29 10:16:47 2013
SMON: enabling cache recovery
Mon Jul 29 10:16:47 2013
Errors in file d:\oracle\admin\system\udump\system_ora_1440.trc:
ORA-00600: 内部错误代码，参数: [4193], [44], [50], [], [], [], [], []

Mon Jul 29 10:16:48 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 298 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 298 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SYSTEM\REDO03.LOG
Mon Jul 29 10:16:49 2013
Errors in file d:\oracle\admin\system\udump\system_ora_1440.trc:
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00607: 当更改数据块时出现内部错误
ORA-00600: 内部错误代码，参数: [4193], [44], [50], [], [], [], [], []

Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 1440
ORA-1092 signalled during: ALTER DATABASE OPEN...

alert里面文字太多，黏贴一部分内容，如果有需要继续传，高手帮帮忙哈，着急~~~

[惜分飞]

引用 2 楼 shaojie0726 的回复:

您能说的详细点吗~呵呵 我是新手，我们公司做软件开发的，oracle用的很肤浅~~

你这个问题不太难，如果你自己搞不定，加我qq 107644445

[Wentasy]

start force;

[sliven1]

你尝试一下open force，强制打开后将数据导出来，重新建库，错误可以慢慢分析

[忆尘]

您能说的详细点吗~呵呵 我是新手，我们公司做软件开发的，oracle用的很肤浅~~

[my_shan]

先备份你的datafile,controlfile,spfile ORA-01092 错误提示 是redo坏了， ORA-00600 [4193] 错误提示 貌似是undo坏了 ORA-00600: [4193] 将 alter system set undo_management=manual scope=spfile; 打开后执行ddl还会报错ORA-00600: [4193] 删除原undo表空间并将undo_management改回auto 后正常 alter system set undo_management=auto scope=spfile; alter system set undo_tablespace=undo2 scope=spfile; shutdown immediate; startup; ORA-01092: ORACLE instance terminated. Disconnection forced 启动数据库到mount状态 SQL> startup mount 可以看到，数据库没有CRASH.现在我们CLEAR GROUP4，先用alter database clear logfile group 4;（如果不行就用alter database clear unarchived logfile group 4;）： SQL> alter database clear logfile group 4; 数据库已更改。 SQL> alter database open; 数据库已更改.