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>