处理数据库无打开问题

1.登陆到sqlplus处理过程


login as: oracle
oracle@172.16.100.71's password:
Last login: Thu Jan  3 01:38:19 2013 from 172.16.100.70
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$ ifconfig
eth0      Link encap:Ethernet  HWaddr 00:50:56:AC:1C:EA
          inet addr:172.16.100.71  Bcast:172.16.100.255  Mask:255.255.255.0
          inet6 addr: fe80::250:56ff:feac:1cea/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:2400205 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1840303 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:665012990 (634.2 MiB)  TX bytes:534050384 (509.3 MiB)


lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:138215 errors:0 dropped:0 overruns:0 frame:0
          TX packets:138215 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:11058200 (10.5 MiB)  TX bytes:11058200 (10.5 MiB)


[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$ ps -ef|grep ora
root      1661  1613  0 Jan01 ?        00:01:47 hald-addon-storage: polling /dev/sr0 (every 2 sec)
oracle    2077     1  0 Jan01 ?        00:06:24 /oracle/product/11.1/db_1/bin/tnslsnr LISTENER -inherit
root      6756  1736  0 01:38 ?        00:00:00 sshd: oracle [priv]
oracle    6760  6756  0 01:38 ?        00:00:00 sshd: oracle@pts/0
oracle    6761  6760  0 01:38 pts/0    00:00:00 -bash
oracle    7076     1  0 01:40 ?        00:00:00 ora_pmon_veims
oracle    7078     1  0 01:40 ?        00:00:00 ora_psp0_veims
oracle    7080     1  3 01:40 ?        00:01:20 ora_vktm_veims
oracle    7084     1  0 01:40 ?        00:00:00 ora_gen0_veims
oracle    7086     1  0 01:40 ?        00:00:00 ora_diag_veims
oracle    7088     1  0 01:40 ?        00:00:00 ora_dbrm_veims
oracle    7090     1  0 01:40 ?        00:00:01 ora_dia0_veims
oracle    7092     1  0 01:40 ?        00:00:00 ora_mman_veims
oracle    7094     1  0 01:40 ?        00:00:00 ora_dbw0_veims
oracle    7096     1  0 01:40 ?        00:00:00 ora_lgwr_veims
oracle    7098     1  0 01:40 ?        00:00:00 ora_ckpt_veims
oracle    7100     1  0 01:40 ?        00:00:00 ora_smon_veims
oracle    7102     1  0 01:40 ?        00:00:00 ora_reco_veims
oracle    7104     1  0 01:40 ?        00:00:00 ora_mmon_veims
oracle    7106     1  0 01:40 ?        00:00:00 ora_mmnl_veims
oracle    7108     1  0 01:40 ?        00:00:00 ora_d000_veims
oracle    7110     1  0 01:40 ?        00:00:00 ora_s000_veims
root     11183  1736  0 02:14 ?        00:00:00 sshd: oracle [priv]
oracle   11189 11183  0 02:14 ?        00:00:00 sshd: oracle@pts/1
oracle   11190 11189  0 02:14 pts/1    00:00:00 -bash
oracle   11488 11190  0 02:16 pts/1    00:00:00 ps -ef
oracle   11489 11190  0 02:16 pts/1    00:00:00 grep ora
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$ id
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper)
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$ echo $ORACLE_SID
veims
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$
[oracle@yzhbdb ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 3 02:16:30 2013


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




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> select open_mode from v$database;


OPEN_MODE
----------------------------------------
MOUNTED


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[1748], [26968], [28385], [], [], [], [], [], [], []




SQL> ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
SP2-0734: unknown command beginning "ORA-00600:..." - rest of line ignored.
SQL> show parameter diag


NAME
------------------------------------
TYPE
----------------------------------------------------------------
VALUE
------------------------------
diagnostic_dest
string
/oracle
SQL> RECOVER DATABASE ;
ORA-00283: recovery session canceled due to errors
ORA-00742: Log read detects lost write in thread %d sequence %d block %d
ORA-00312: online log 2 thread 1: '/data/veims/redo02.log'




SQL>
SQL>
SQL> RECOVER DATABASE UNTIL CANCEL;
ORA-00279: change 131907224 generated at  needed for thread 1




Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00266: name of archived log file needed




ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/veims/system01.dbf'




SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'D:/1.TXT';
ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'D:/1.TXT'
*
ERROR at line 1:
ORA-01278: error creating file '/oracle/product/11.1/db_1/dbs/D:/1.TXT'
ORA-27300: OS system dependent operation:open failed failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: SlfFopen1




SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'D:\1.TXT';


Database altered.


SQL>  recover database using backup controlfile until cancel;
ORA-00279: change 131907224 generated at 09/09/2017 05:50:03 needed for thread
1
ORA-00289: suggestion :
/oracle/fast_recovery_area/VEIMS/archivelog/2013_01_03/o1_mf_1_1748_%u_.arc
ORA-00280: change 131907224 for thread 1 is in sequence #1748




Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
'/data/veims/redo02.log'
Log applied.
Media recovery complete.
SQL>
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open




SQL> alter database open resetlogs;


Database altered.


SQL> select open_mode from v$database;


OPEN_MODE
----------------------------------------
READ WRITE


SQL>
SQL>
SQL> select open_mode from v$database;


OPEN_MODE
----------------------------------------
READ WRITE


SQL>
SQL>
SQL>
SQL>














2.alert日志输出情况


[oracle@yzhbdb trace]$ tail -100f alert_veims.log
 started logmerger process
Parallel Media Recovery started with 4 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER  DATABASE UNTIL CANCEL  ...
Thu Jan 03 02:24:33 2013
ALTER DATABASE RECOVER    CONTINUE DEFAULT
Thu Jan 03 02:24:33 2013
Errors in file /oracle/diag/rdbms/veims/veims/trace/veims_pr00_12554.trc:
ORA-00266: name of archived log file needed
ORA-266 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...
ALTER DATABASE RECOVER CANCEL
Errors in file /oracle/diag/rdbms/veims/veims/trace/veims_pr00_12554.trc:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/veims/system01.dbf'
ORA-1547 signalled during: ALTER DATABASE RECOVER CANCEL ...
Thu Jan 03 02:25:39 2013
ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'D:/1.TXT'
ORA-1278 signalled during: ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'D:/1.TXT'...
Thu Jan 03 02:26:33 2013
ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'D:\1.TXT'
Completed: ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'D:\1.TXT'
Thu Jan 03 02:29:18 2013
ALTER DATABASE RECOVER  database using backup controlfile until cancel
Media Recovery Start
 started logmerger process
Thu Jan 03 02:29:18 2013
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 5 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
Parallel Media Recovery started with 4 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER  database using backup controlfile until cancel  ...
Thu Jan 03 02:30:56 2013
ALTER DATABASE RECOVER    LOGFILE '/data/veims/redo02.log'
Media Recovery Log /data/veims/redo02.log
Thu Jan 03 02:30:57 2013
Incomplete recovery applied all redo ever generated.
Recovery completed through change 131908116 time 09/09/2017 06:09:19
Media Recovery Complete (veims)
Completed: ALTER DATABASE RECOVER    LOGFILE '/data/veims/redo02.log'
Thu Jan 03 02:31:15 2013
alter database open
Errors in file /oracle/diag/rdbms/veims/veims/trace/veims_ora_11557.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open...
alter database open resetlogs
RESETLOGS after complete recovery through change 131908116
Clearing online redo logfile 1 /data/veims/redo01.log
Clearing online log 1 of thread 1 sequence number 1747
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 /data/veims/redo02.log
Clearing online log 2 of thread 1 sequence number 1748
Thu Jan 03 02:31:25 2013
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 /data/veims/redo03.log
Clearing online log 3 of thread 1 sequence number 1746
Clearing online redo logfile 3 complete
Resetting resetlogs activation ID 2558931956 (0x988633f4)
Online log /data/veims/redo01.log: Thread 1 Group 1 was previously cleared
Online log /data/veims/redo02.log: Thread 1 Group 2 was previously cleared
Online log /data/veims/redo03.log: Thread 1 Group 3 was previously cleared
Thu Jan 03 02:31:25 2013
Setting recovery target incarnation to 6
Thu Jan 03 02:31:25 2013
Assigning activation ID 2559012189 (0x98876d5d)
Thread 1 opened at log sequence 1
  Current log# 1 seq# 1 mem# 0: /data/veims/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jan 03 02:31:25 2013
SMON: enabling cache recovery
[11557] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:148491754 end:148492114 diff:360 (3 seconds)
Dictionary check beginning
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Thu Jan 03 02:31:28 2013
QMNC started with pid=19, OS id=13427
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: alter database open resetlogs
Thu Jan 03 02:34:10 2013
XDB installed.
XDB initialized.
Thu Jan 03 02:36:31 2013
Starting background process SMCO
Thu Jan 03 02:36:31 2013
SMCO started with pid=43, OS id=13498