admin

ORA-00600: internal error code, arguments: [4194]故障处理

admin 数据库 2021-04-27 156浏览 0

在启动数据库实例时遇到“ORA-00600: internal error code, arguments: [4194].....”错误,实例在启动后,会自然Down掉。具体情况如下所示:

................................................................................

................................................................................

 

ORA-00600: internal error code, arguments: [4194], [52], [29], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194]Non-fatal internal error happenned while SMON was doing temporary segment drop.

这个错误,官方文档Step by step to resolve ORA-600 4194 4193 4197 on database crash (文档 ID 1428786.1)有提供详细的介绍。建议处理前,建议先查阅次文档,错误出现的主要场景:


This issue generally occurs when there is a power outage or hardware failure that initially crashes the database. On startup, the database does the normal roll forward (redo) and then rollback (undo), this is where the error is generated on the rollback.

具体操作如下所示

Step 1: 通过spfile创建生成pfile

SQL> create pfile from spfile;

File created.

Step 2: 关闭数据库实例。

SQL> shutdown immediate

Step 3:修改pfile中undo_management为MANUAL

[oracle@DB-Server dbs]$ vi initorcl.ora

*.undo_management='MANUAL' 

*.undo_tablespace='UNDOTBS'

 

Step 4: 使用PFILE启动数据库

[oracle@DB-Server dbs]$ sqlplus / as sysdba


SQL> startup restrict pfile='initorcl.ora'


Step 5: 新建一个UNDO表空间

SQL> create undo tablespace UNDOTBS1 datafile '/u04/epps/oradata/undotbs_01.dbf' size 4G;

Tablespace created.

Step 6: 删除旧的UNDO表空间


SQL> drop tablespace UNDOTBS including contents and datafiles;

Tablespace dropped.

Step7:关闭数据库实例

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit


Step 8:启动数据库实例到NOMOUNT状态

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1.6777E+10 bytes

Fixed Size                  2113368 bytes

Variable Size            9982443688 bytes

Database Buffers         6777995264 bytes

Redo Buffers               14663680 bytes


Step 9:修改spfile中的undo_tablespace参数

SQL> alter system set undo_tablespace='UNDOTBS1' scope=spfile;

System altered.

 

Setp 10:关闭数据库实例。

SQL> shutdown immediate;

Step 11:启动数据库实例(使用spfile)

SQL> startup;

ORACLE instance started.

 

Total System Global Area 1.6777E+10 bytes

Fixed Size                  2113368 bytes

Variable Size            9982443688 bytes

Database Buffers         6777995264 bytes

Redo Buffers               14663680 bytes

Database mounted.

Database opened.


版权声明

本站《作品展示》类文章均为原创,转载必须注明出处,技术分享类文章部分来源于网络,版权归原作者所有,若侵权请留言。

发表评论
展开