100分求个数据库启动时报错问题

[碧水幽幽泉]

今天下午，项目组数据库在断电后，突然起不来了。
时间紧迫，希望大家帮忙解决下，
错误信息如下：

SQL> startup mount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> alter database open;

ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 5711
Session ID: 170 Serial number: 5

部分alert日志信息如下：

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL =TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /home/oracle/db
Wed Aug 18 06:04:06 2010
ALTER DATABASE MOUNT
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 3058720473
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
linux-5vs9.site
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /home/oracle/db
Wed Aug 18 06:04:06 2010
ALTER DATABASE MOUNT
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 3058720473
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Aug 18 06:18:00 2010
Starting ORACLE instance (normal)
Wed Aug 18 06:19:09 2010
db_recovery_file_dest_size of 3072 MB is 0.00% used. This is a
user-specified limi
t on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Aug 18 06:19:15 2010
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
Shutting down instance (immediate)
License high water mark = 3
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT

[碧水幽幽泉]

SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile /home/oracle/db/product/11.1.0/db_1/dbs/spfileesbdb.ora
System parameters with non-default values:
processes = 150
sga_target = 984M
control_files = "/home/oracle/db/oradata/esbdb/control01.ctl"

control_files = "/home/oracle/db/oradata/esbdb/control02.ctl"
control_files = "/home/oracle/db/oradata/esbdb/control03.ctl"
db_block_size = 8192
compatible = "11.1.0.0.0"
db_recovery_file_dest = "/home/oracle/db/flash_recovery_area"
db_recovery_file_dest_size= 3G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=esbdbXDB)"
job_queue_p
rocesses = 1000
audit_file_dest = "/home/oracle/db/admin/esbdb/adump"
audit_trail = "DB"
db_name = "esbdb"
open_cursors = 300
pga_aggregate_target = 327M
diagnostic_dest = "/home/oracle/db"

[碧水幽幽泉]

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Aug 18 06:26:39 2010
MMNL started with pid=15, OS id=6332
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /home/oracle/db
Wed Aug 18 06:26:39 2010
ALTER DATABASE MOUNT
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 3058752290
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT

[Dave]

Starting up ORACLE RDBMS Version: 11.1.0.6.0.
-- 可能是Oracle 的bug.

[Dave]

如果有备份的话，恢复一下。


Symptoms
Database down and the error below appears while trying to startup

SQL> startup
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size 1268508 bytes
Variable Size 1124074724 bytes
Database Buffers 1006632960 bytes
Redo Buffers 15507456 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

Cause
Some datafiles were offline.

ORACLE instance terminated. Disconnection forced so this might cause the datafiles to be offlined
Solution
Check if you have a good backup from which you can restore any problematic data file.

1) first restore the problematic datafile.

2) mount the database

SQL > recover database;

And then try to open the database

SQL > alter database open ;


3) Try to find if there are any offline files by checking the recover_file.

SQL> select * from v$recover_file;

For example:-

11 OFFLINE OFFLINE
2489793132
30-JAN-09

20 OFFLINE OFFLINE
2489793132

4) Recover the offline datafiles that were appearing from above select statement,

i.e.

SQL> recover datafile 11,20;

Media recovery complete.

5) Bring these datafiles back online,

i.e

SQL> alter database datafile 11,20 online;

Database altered.

6) To ensure no more files just check again the recover_file view, then you can safely open the database

SQL> select * from v$recover_file;
no rows selected



------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群：62697716(满); DBA2 群：62697977(满)
DBA3 群：63306533; 聊天 群：40132017

[Phoenix_99]

startup force

[碧水幽幽泉]

[Quote=引用 5 楼 phoenix_99 的回复:]
startup force
[/Quote]
startup force 也是报错！

[luoyoumou]

shutdown abort;
starrtup;

-- 这样试试

[碧水幽幽泉]

[Quote=引用 7 楼 luoyoumou 的回复:]
shutdown abort;
starrtup;

-- 这样试试
[/Quote]
还是不行！
数据库没有备份，难道只能重装了？

[碧水幽幽泉]

[心中的彩虹]

从你的说法说是断电ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

set oracle_sid='实例名'

[Michael_Cao_Zhi]

是主机的定义出了问题;

[碧水幽幽泉]

[碧水幽幽泉]

[Quote=引用 12 楼 michael_cao_zhi 的回复:]
是主机的定义出了问题;
[/Quote]
什么是主机的定义？

[jspwind]

我想先查进程是否还有在。有进程死掉了吧。

[yuxinglian]

纯对的 bug
========================================================
ORA-01041:

internal error. hostdef extension doesn't exist

Cause: Pointer to hstdef extension in hstdef is null.

Action: Report as a bug


Oracle Product Document Library (C) Oracle Corporation
Manual: Oracle Database Error Messages
Reference: B28278-01