ORACLE Normal User logon error: ora-01033:oracle initialization or shutdown in Progress____oracle

SYSDBA users can log in, the normal user login error is as follows:

[Oracle@dbserver ~]$ Sqlplus/nolog

Sql*plus:release 11.2.0.1.0 Production on Mon Oct 17 21:07:09 2016

Copyright (c) 1982, 2009, Oracle. All rights reserved.

sql> Conn zs/123456

ERROR:

Ora-01033:oracle initialization Orshutdown in progress

Process id:0

Session id:0 Serial number:0

Warning:you are no longer connected to ORACLE.

Solution:
sql> conn/as sysdba

Connected.
#正常

sql> shutdown Normal

Ora-01109:database not open

Database dismounted.

ORACLE instance shut down.

Sql> Startup Mount

ORACLE instance started.

Total System Global area 1.3429E+10 bytes

Fixed Size 2217992 bytes

Variable Size 7113541624 bytes

Database buffers 6241124352 bytes

Redo buffers 71770112 bytes

Database mounted.

sql> ALTER DATABASE open;

ALTER DATABASE Open

*

ERROR at line 1:

Ora-01589:must use resetlogs or noresetlogs option Fordatabase Open

sql> ALTER DATABASE open resetlogs;

ALTER DATABASE open Resetlogs

*

ERROR at line 1:

Ora-01194:file 1 needs more recovery to be consistent

Ora-01110:data file 1: '/HOME/APP/ORACLE/ORADATA/ORCL/SYSTEM01.DBF '

sql> recover database using Backup controlfile until cancel;

Ora-00279:change 198456936 generated at 10/17/201601:15:48 needed for thread

1

Ora-00289:suggestion:/arlog/1_692_925425318.dbf

Ora-00280:change 198456936 for thread 1 is insequence #692

Specify log: {<ret>=suggested | AUTO | CANCEL}

Cancel

Ora-10879:error signaled in parallel recovery slave

Ora-01547:warning:recover succeeded but OPEN resetlogswould get error below

Ora-01194:file 1 needs more recovery to be consistent

Ora-01110:data file 1: '/HOME/APP/ORACLE/ORADATA/ORCL/SYSTEM01.DBF '

#查询redo Log

sql> Select V1.group#,member, sequence#, first_change#

2 from V$log v1, V$logfilev2

3 where v1.group# =v2.group#;

group#

----------

Member

--------------------------------------------------------------------------------

sequence# first_change#

---------- -------------

1

/home/app/oracle/oradata/orcl/redo01.log

691 198456085

3

/home/app/oracle/oradata/orcl/redo03.log

690 198455630

group#

----------

Member

--------------------------------------------------------------------------------

sequence# first_change#

---------- -------------

2

/home/app/oracle/oradata/orcl/redo02.log

692 198456936

Based on the previous error tip: Ora-00280:change 198456936 for thread 1 was in sequence #692
Locate the corresponding log name through First_change and sequence/home/app/oracle/oradata/orcl/redo02.log

sql> recover database using Backup controlfile until cancel;

Ora-00279:change 198456936 generated at 10/17/201601:15:48 needed for thread

1

Ora-00289:suggestion:/arlog/1_692_925425318.dbf

Ora-00280:change 198456936 for thread 1 was in sequence#692

Specify log: {<ret>=suggested | AUTO | CANCEL}

/home/app/oracle/oradata/orcl/redo02.log

Log applied.

Media recovery complete.

sql> ALTER DATABASE open resetlogs;

Database altered.

sql> Conn zs/123456

Connected.

Sql>