欢迎投稿

今日深度：

> > 正文

ORA-00600ORA-01565ORA-27046

来源:未知 阅读:16249 评论 196 热度3

标签：

ORA-00600ORA-01565ORA-27046


昨天在做数据泵导入导出的时候，突然遇到ude-00008错误，查看日志文件：
<span style="font-size:10px;">Errors in file /oracle/afcprd01/db/10.2.0/admin/afcprd01_afcdb/bdump/afcprd01_dbw0_1417220.trc: 
ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [1565], [], [], [], [], [], [] 
ORA-01565: error in identifying file '/oracle/afcprd01/db/10.2.0/dbs/spfileafcprd01.ora' 
ORA-27046: file size is not a multiple of logical block size 
Additional information: 1 
Additional information: 2759 
Additional information: 512 
DBW0: terminating instance due to error 471 
Instance terminated by DBW0, pid = 1417220</span>

数据库已经宕机了，spfile损坏了，具体怎么损坏的，也不清楚。既然如此，就只有恢复spfile了。

MOS上面给出非常详细的方案：

ORA-600 [kmgs_parameter_update_timeout_1], [1565], Instance Terminated, Can't Startup Using Either Pfile Or Spfile (Doc ID 960080.1) To BottomTo Bottom \
vcmRlcj0="0" cellpadding="0" cellspacing="0" width="100%">

In this Document
Symptoms
Cause
Solution
References

APPLIES TO:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later [Release: 10.2 and later ]
Information in this document applies to any platform.

SYMPTOMS

Instance terminated with the following error :

Errors in file /oracle/afcprd01/db/10.2.0/admin/afcprd01_afcdb/bdump/afcprd01_dbw0_1417220.trc:
ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [1565], [], [], [], [], [], []
ORA-01565: error in identifying file '/oracle/afcprd01/db/10.2.0/dbs/spfileafcprd01.ora'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Additional information: 2759
Additional information: 512
DBW0: terminating instance due to error 471
Instance terminated by DBW0, pid = 1417220
Now, database can not be started using either pfile or spfile.

CAUSE

In this case, this is looking spfile corruption issue, due to which database can not be open, but pfile is also having some problem, possibly some junk character is there, which not allowing to open the database using pfile.

SOLUTION

To solve the issue related to corrupted PFILE/SPFILE , please follow the below steps.

- Restore any old valid pfile / spfile from backup

OR

- If the backup of the pfile / spfile is not available , try to get the instance startup parameters from the alert log from last startup.

OR

- If the backup of the pfile / spfile nor old alert log is not available , follow the below steps:

Startup the database in restricted mode using a new pfile.
This new pfile should be created using old pfile by copying all the parameters one-by-one.

First make it with minimum values, just to startup and check the possibility that there is even a problem with the new pfile.

-- If it is unsuccessful, then there might be an issue with new pfile also.
-- Now, edit and copy all the parameters in it one-by-one from old pfile.
-- Open the database with new pfile again.
-- Once database is open, create spfile from this new pfile.
-- Shutdown the database.
-- Startup the database with the spfile now.


www.htsjk.Com true http://www.htsjk.com/oracle/23151.html NewsArticle ORA-00600ORA-01565ORA-27046 昨天在做数据泵导入导出的时候，突然遇到ude-00008错误，查看日志文件： span style=font-size:10px;Errors in file /oracle/afcprd01/db/10.2.0/admin/afcprd01_afcdb/bdump/afcprd01_dbw0_141722...
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。
返回首页
相关文章
    暂无相关文章
评论暂时关闭