ORA-00600: internal error code, arguments: [3705]

最新推荐文章于 2022-01-02 19:14:18 发布

cqz65458

最新推荐文章于 2022-01-02 19:14:18 发布

阅读量259

点赞数

文章标签：数据库

转自：

http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora00600-internal-error-code-arguments-3-very-urgent-149704

[@more@] On Fri, 4 Oct 2002, William_Long_JOBS via oracle-db-l wrote:

Hi
Real thanks for U.. I tried creating a trace but that doesn't work first..
than I tried using my old ctl files backup.then with the trace i recreated
them with the New ones..
atlast it worked me (pwd file was also corrupted by when i recreated the
ctl file everything worked well)..

> Oracle news updated daily -
http://www.ittoolbox.com/i/or.asp >
> This metalink article suggests re-creating the control file by editing the
> script generated with the command 'backup control file to trace' and then
> executing the resultant script. You would then do a 'Recover with a backup
> control file' (Case 8 in my Oracle Backup and Recovery Manual).
>
> There are other articles in Metalink.
> Do you have Metalink? Why Not?
>
> As with all Oracle errors, this may not be the final or real solution.
> What's in the trace file identified in the alert log?
> I'll give more information if needed.
> Bill
>
> -----Original Message-----
> From: Anzer via oracle-db-l [mailto:oracle-db-l@OpenITx.com]
> Sent: Friday, October 04, 2002 2:58 PM
> To: William_Long_JOBS
> Subject: [oracle-db-l] RE: ORA-00600: internal error code, arguments: [3....
> VERY URGENT
>
> Oracle news updated daily - http://www.ittoolbox.com/i/or.asp
> Can u explain the three points on solution desc clearly please..
>
>
> On Fri, 4 Oct 2002, William_Long_JOBS via oracle-db-l wrote:
> > Oracle news updated daily - http://www.ittoolbox.com/i/or.asp
> >
> > >From Metalink:
> >
> > Problem Description
> >
> > You are trying to startup the database. It mounts but will not open.
> > When it opens the following errors are reported:
> >
> > ORA 00449
> > 00449, 00000, "background process '%s' unexpectedly terminated with error
> > %s"
> > // *Cause: A foreground process needing service from a background
> > // process has discovered the process died.
> > // *Action: Consult the error code, and the trace file for the process.
> >
> >
> > ORA 00470
> > 00470, 00000, "LGWR process terminated with error"
> > // *Cause: The log writer process died
> > // *Action: Warm start instance
> >
> > ORA 01092
> > 01092, 00000, "ORACLE instance terminated. Disconnection forced"
> > // *Cause: The instance this process was connected to was terminated
> > // abnormally, probably via a shutdown abort. This process
> > // was forced to disconnect from the instance.
> > // *Action: When instance has been restarted, retry action.
> >
> >
> > The Alert log shows ORA-600[3705]
> >
> > Solution Description
> >
> > 1. Issue the command 'Alter Database Backup Controlfile to Trace;'
> >
> > 2. Edit the subsequent trace file.
> >
> > a. Remove everything above the 'STARTUP NOMOUNT' line.
> > b. Change 'STARTUP NOMOUNT' to
> > 'STARTUP NOMOUNT PFILE='.
> >
> > 3. Run the create controlfile script.
> >
> > Solution Explanation:
> >
> > Normally if a database will successfully mount we do not suspect problems
> > with
> > the controlfile. However, in this case, the corruption is not found until
> we
> > open the database.
> >
> > When we open the database we check a flag in the current online redo log
> and
> > if
> > that flag does not match the flag for that thread in the controlfile then
> we
> > signal the ora-600 [3705].
> >
> > In this particular situation an import was causing excessive redo log
> > switches
> > because the Redo Logs were only 200k. This caused corruption in the
> > controlfile. Rebuilding the controlfile alleviated part of the problem.
> > However, it took several minutes for the database to open because we were
> > waiting for SMON to complete cache recovery. Once the database opened
> and
> > the checkpoint was completed, a subsequent shutdown and restart was
> > completed
> > within seconds.
> >
> > Solution References:
> >
> > Similar to BUG# 366131, though Parallel server was involved.
> >
> > [NOTE:1012929.6] How To Recreate The Controlfile
> > .
> >
> > -----Original Message-----
> > From: Anzer via oracle-db-l [mailto:oracle-db-l@OpenITx.com]
> > Sent: Friday, October 04, 2002 12:33 PM
> > To: William_Long_JOBS
> > Subject: [oracle-db-l] ORA-00600: internal error code, arguments: [3....
> > VERY URGENT
> >
> > Oracle news updated daily - http://www.ittoolbox.com/i/or.asp
> >
> >
> >
> > When I startup data base its giving the
> >
> > onnected.
> > SVRMGR> startup
> > ORACLE instance started.
> > Total System Global Area 338935968 bytes
> > Fixed Size 73888 bytes
> > Variable Size 170557440 bytes
> > Database Buffers 167772160 bytes
> > Redo Buffers 532480 bytes
> > Database mounted.
> > ORA-03113: end-of-file on communication channel
> >
> > When I chked the alert log it has reported the following..
> >
> >
> > Fri Oct 4 06:45:07 2002
> > alter database open
> > Fri Oct 4 06:45:07 2002
> > Errors in file /u01/app/oracle/admin/dual/bdump/lgwr_1220.trc:
> > ORA-00600: internal error code, arguments: [3705], [1], [2], [2], [2], [],
> > [], [
> > ]
> > Fri Oct 4 06:45:08 2002
> >
> >
> > What shud be done... its production database ... so some immdiate replies
> > are welcome..
> >
> >
> >
> >
> > *****************FREE ECperf benchmark report******************
> > >From Oracle9i Application Server.
> > http://www.ittoolbox.com/r/oracle71.asp
> > ***************************************************************
> > *Archives: http://www.OpenITx.com/g/oracle-db-l.asp
> > *Unsubscribe: mailto:leave-oracle-db-l@openitx.com
> > *Terms of Use: http://www.ittoolbox.com/help/termsofuse.htm
> > *Copyright (c) ITtoolbox and message author. No redistribution.
> >
> >
> >
> >
> > *****************FREE ECperf benchmark report******************
> > >From Oracle9i Application Server.
> > http://www.ittoolbox.com/r/oracle71.asp
> > ***************************************************************
> > *Archives: http://www.OpenITx.com/g/oracle-db-l.asp
> > *Unsubscribe: mailto:leave-oracle-db-l@openitx.com
> > *Terms of Use: http://www.ittoolbox.com/help/termsofuse.htm
> > *Copyright (c) ITtoolbox and message author. No redistribution.
> >
>
>
> *****************FREE ECperf benchmark report******************
> >From Oracle9i Application Server.
> http://www.ittoolbox.com/r/oracle71.asp
> ***************************************************************
> *Archives: http://www.OpenITx.com/g/oracle-db-l.asp *Unsubscribe:
> mailto:leave-oracle-db-l@openitx.com *Terms of Use:
> http://www.ittoolbox.com/help/termsofuse.htm *Copyright (c) ITtoolbox and
> message author. No redistribution.
>
>
>
>
> *****************FREE ECperf benchmark report******************
> >From Oracle9i Application Server.
> http://www.ittoolbox.com/r/oracle71.asp
> ***************************************************************
> *Archives: http://www.OpenITx.com/g/oracle-db-l.asp
> *Unsubscribe: mailto:leave-oracle-db-l@openitx.com
> *Terms of Use: http://www.ittoolbox.com/help/termsofuse.htm
> *Copyright (c) ITtoolbox and message author. No redistribution.
>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/319336/viewspace-896296/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/319336/viewspace-896296/