数据库关机异常 - 欢迎大师来指导

突然想起来前两天服务器升级时候正常关闭主库没反应，等了半个小时我采取了强制极端操作服务进程也全kill了，但是还是有问题，sqlplus没有任何反映。下面来根据命令窗口回溯吧。关机[oracle@hostname 2025-03-08_22:46:55 ~] $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 8 22:48:16 2025 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, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options SQL> alter system switch logfile; System altered. SQL> shutdown immediate 等了15分钟没反应查看日志Sat Mar 08 23:08:46 2025 Shutting down instance (immediate) Stopping background process SMCO Shutting down instance: further logons disabled Stopping background process QMNC Stopping background process MMNL Stopping background process MMON License high water mark = 1934 All dispatchers and shared servers shutdown Sat Mar 08 23:08:57 2025 PMON failed to delete process, see PMON trace file PMON deletion of process succeeded Sat Mar 08 23:08:58 2025 ALTER DATABASE CLOSE NORMAL Sat Mar 08 23:08:58 2025 SMON: disabling tx recovery SMON: disabling cache recovery Sat Mar 08 23:08:59 2025 Shutting down archive processes Archiving is disabled Sat Mar 08 23:08:59 2025 ARCH shutting down Sat Mar 08 23:08:59 2025 Sat Mar 08 23:08:59 2025 ARCH shutting downARCH shutting down Sat Mar 08 23:08:59 2025 ARCH shutting down ARC1: Archival stopped ARC0: Archival stoppedARC3: Archival stopped ARC2: Archival stopped Thread 1 closed at log sequence 280887 Successful close of redo thread 1本来想杀掉local=on，发现没有，后来直接把系统的也杀掉了[oracle@hostname 2025-03-08_23:13:26 ~] $ ps -ef | grep local=on oracle 170608 168507 0 23:13 pts/3 00:00:00 grep local=on [oracle@hostname 2025-03-08_23:24:38 ~] $ ps -ef|grep -v grep|grep ora_|awk '{print $2}'|xargs kill -9 会话杀了之后第一反应是当前连接的会话被断开，但是日志也没有任何反映，重连也无法做任何操作 ORA-03113: end-of-file on communication channel Process ID: 166858 Session ID: 5187 Serial number: 54647 SQL> shutdown immediate ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options [oracle@hostname 2025-03-08_23:26:57 ~] $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Mar 8 23:27:00 2025 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected. SQL> startup nomount ORA-01012: not logged on SQL> ps -ef | grep ora_ SP2-0734: unknown command beginning "ps -ef | g..." - rest of line ignored. SQL> exit Disconnected最后这个做了DG强制切换启动了新服务器，这个服务器重启了，但是半天没反应就没管他，过了两天服务器被弄起来了我在登陆上去看可以启动到nomount状态。