我的Oracle 登不上去报措

Question

我的Oracle　10G 登不上去报措：
ORA-01033 ORACLE initialization or shutdown in progress
怎么解决啊！！
  用系统默认的scott/tiger   system/mamager 登不上去。
　刚刚安装好时这个账号能登陆的，用了没几次就报这个错误，
　Oracle 全部服务启动了也没用

Answer 1

一步一步走一一遍，看看具体是哪一步报错，错误信息是什么！sqlplus /nologsql> conn / as sysdbasql> startup nomountsql> alter database mount;sql> alter database open;

Answer 2

输入conn   /   as   sysdba 　　　　结果是：ERROR:
　　　　　　　　　　　　　　　　　　　　　　　　　ORA-01033: ORACLE initialization or shutdown in progress
输入conn   /   as   sysdba 　　　　结果是：Enter password: manager
                                                  Connected to:
                                                  Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -           Production
                                                  With the Partitioning, OLAP and Data Mining options
                                                  SQL> select * from tab;
                                                  select * from tab
                                                                    *
                                                  ERROR at line 1:
                                                  ORA-01219: database not open: queries allowed on fixed   tables/views only
输入：startup   nomount            结果是：ORA-01081: cannot start already-running ORACLE - shut it down first
输入：alter   database   mount; 　 结果是：alter   database   mount
                                           *
                                           ERROR at line 1:
                                           ORA-01100: database already mounted 
输入：alter   database   open;　　 结果是:alter   database   open
                                          *
                                          ERROR at line 1:
                                          ORA-00313: open failed for members of log group 1 of thread 1
                                          ORA-00312: online log 1 thread 1:
                                          'F:\ORACLE\PRODUCT\10.1.0\ORADATA\ACCP\REDO01.LOG'

Answer 3

以sys登录为sysdba
sqlplus /NOLOG
SQL>connect sys/用户口令as sysdba
SQL>shutdown normal
SQL>startup mount
SQL>alter database open
SQL>shutdown normal
SQL>startup

Answer 4

以sys/sys as sysdba登录            
输入：sqlplus   /NOLOG             结果是：SP2-0734: unknown command beginning "sqlplus   ..." - rest of line ignored.
输入：connect   sys/sys as sysdba  结果是：Connected.
输入：shutdown   normal            结果是：ORA-01109: database not open
                                           Database dismounted.
                                           ORACLE instance shut down.
输入：startup   mount              结果是：ORACLE instance started.
                                           Total System Global Area  171966464 bytes
                                           Fixed Size                   787988 bytes
                                           Variable Size             145488364 bytes
                                            Database Buffers           25165824 bytes
                                           Redo Buffers                 524288 bytes
                                           Database mounted.
输入:alter   database   open        结果是：2输入:shutdown   normal              结果是：ORA-01109: database not open
                                            Database dismounted.
                                            ORACLE instance shut down.
输入:startup                        结果是：ORACLE instance started.                                            Total System Global Area  171966464 bytes
                                            Fixed Size                   787988 bytes
                                            Variable Size             145488364 bytes
                                            Database Buffers           25165824 bytes
                                            Redo Buffers                 524288 bytes
                                            Database mounted.
                                            ORA-00313: open failed for members of log group 1 of thread 1
                                            ORA-00312: online log 1 thread 1:
                                            'F:\ORACLE\PRODUCT\10.1.0\ORADATA\ACCP\REDO01.LOG'

Answer 5

online redo log file 
'F:\ORACLE\PRODUCT\10.1.0\ORADATA\ACCP\REDO01.LOG 有问题了。看看这个文件还在不在！

Answer 6

是啊，'F:\ORACLE\PRODUCT\10.1.0\ORADATA\ACCP\REDO01.LOG   
文件没了怎么办啊，有没有什么办法解决啊！！！