启动数据库时报如下错误:
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 12月 1 21:25:42 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> show recyclebin;
ERROR:
ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-16014: 日志 1 的序列号 230 未归档, 没有可用的目的地
ORA-00312: 联机日志 1 线程 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
SQL> show parameter db_recovery;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:\oracle\product\10.2.0/flash
_recovery_area
db_recovery_file_dest_size big integer 4G
SQL> alter system archvie log current;
alter system archvie log current
*
第 1 行出现错误:
ORA-02065: 非法的 ALTER SYSTEM 选项
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
.3012
看来不是 db_recovery_file_dest_size 的问题。
查看alert_orcl.log 文件,发现如下错误:
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_1792.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 112) 磁盘空间不足。
在查看bdump 已经18G,把甚于的磁盘空间全给用了。删除后,
alter database open;
数据库正常启动。
产生问题的最终原因是:
Tue Dec 01 21:52:52 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_3620.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 12月 1 21:25:42 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> show recyclebin;
ERROR:
ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-16014: 日志 1 的序列号 230 未归档, 没有可用的目的地
ORA-00312: 联机日志 1 线程 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
SQL> show parameter db_recovery;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:\oracle\product\10.2.0/flash
_recovery_area
db_recovery_file_dest_size big integer 4G
SQL> alter system archvie log current;
alter system archvie log current
*
第 1 行出现错误:
ORA-02065: 非法的 ALTER SYSTEM 选项
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
.3012
看来不是 db_recovery_file_dest_size 的问题。
查看alert_orcl.log 文件,发现如下错误:
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc1_1792.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() 失败, 无法写入文件
O/S-Error: (OS 112) 磁盘空间不足。
在查看bdump 已经18G,把甚于的磁盘空间全给用了。删除后,
alter database open;
数据库正常启动。
产生问题的最终原因是:
Tue Dec 01 21:52:52 2009
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mmon_3620.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13571112/viewspace-621110/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13571112/viewspace-621110/