oracle 10gR2版本对global_name更新为空会导致数据库启动不成功
oracle 10gR2版本对global_name更新为空会导致数据库启动不成功
以下为具体测试过程 10gR2版本
C:\Documents and Settings\Administrator>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 9月 11 12:11:22 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
已连接到空闲例程。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 167772160 bytes
Fixed Size 1247900 bytes
Variable Size 75498852 bytes
Database Buffers 88080384 bytes
Redo Buffers 2945024 bytes
数据库装载完毕。
数据库已经打开。
SQL> update global_name set global_name='';
已更新 1 行。
SQL> commit;
提交完成。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL>
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 167772160 bytes
Fixed Size 1247900 bytes
Variable Size 75498852 bytes
Database Buffers 88080384 bytes
Redo Buffers 2945024 bytes
数据库装载完毕。
ORA-01092: ORACLE 实例终止。强制断开连接
数据库日志记录以下内容:报ORA-00600 18062等错误
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=14, OS id=3520
Sat Sep 11 12:14:16 2010
Errors in file c:\oracle\product\10.2.0\admin\or\udump\or_ora_3508.trc:
ORA-00600: 内部错误代码, 参数: [18062], [], [], [], [], [], [], []
Sat Sep 11 12:14:22 2010
Errors in file c:\oracle\product\10.2.0\admin\or\udump\or_ora_3508.trc:
ORA-00600: 内部错误代码, 参数: [18062], [], [], [], [], [], [], []
Sat Sep 11 12:14:22 2010
Errors in file c:\oracle\product\10.2.0\admin\or\udump\or_ora_3508.trc:
ORA-00600: 内部错误代码, 参数: [18062], [], [], [], [], [], [], []
Sat Sep 11 12:14:22 2010
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 3508
ORA-1092 signalled during: ALTER DATABASE OPEN...
而在oracle 9i版本中没这个问题
SQL_testdb>select * from props$;rows will be truncatedNAME VALUE$------------------------------ -----------------------------------------......省略显示部分内容GLOBAL_DB_NAME TESTDB......省略显示部分内容NLS_RDBMS_VERSION 9.2.0.6.025 rows selected.SQL_testdb>update global_name set global_name=''; 1 row updated.SQL_testdb>commit;Commit complete.SQL_testdb>shutdown abortORACLE instance shut down.SQL_testdb>startup pfile=/dras20/testdb/inittestdb.oraORACLE instance started.Total System Global Area 504858456 bytesFixed Size 743256 bytesVariable Size 285212672 bytesDatabase Buffers 218103808 bytesRedo Buffers 798720 bytesDatabase mounted.Database opened.
通过查metalink id为 743676.1 只对10gR2版本有影响
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
要解决这个问题 只能靠备份来恢复,还有就是通过非常规方法来修复。
所以我们对global_name这个表不能做任何更改,否则后果很严重。