Re: ORA-00600: internal error code

From: Maclean Liu <maclean_007_at_163.com>
Date: Sun, 30 Nov 2014 22:22:39 +0800
Message-ID: <CANkM9ZhGkp_AAmF8_kpzPhcH3DWeqqs7z4XpnijP7ZCr17TYTQ_at_mail.gmail.com>



alter system set event= '10513 trace name context forever , level 2 : 10231 trace name context forever, level 10' scope=spfile;

shutdown immediate;
startup ;

otherwise you'd better upload the alert.log

-ML

--

Maclean Liu
Senior Director Product Management
ParnassusData Software ,Inc.   http://www.parnassusdata.com/
Phone : (+86) 400-690-3643  ;  Mobile : (+86) 13764045638
My Blog: http://askmaclean.com/
4/F, No.733 Gaoping Road Shanghai , China
zip code: 200436

On Sun, Nov 30, 2014 at 10:10 PM, Mostafa Eletriby <
dmarc-noreply_at_freelists.org> wrote:


> Hello ,
> I have the same problem , after running those statements by this
> procedure, database goes down after a while.
>
> shutdown abort;
> startup mount;
> Alter system set events '10513 trace name context forever, level 2';
> alter database open;
>
> Then I restarted again but same problem.
> Please advice.
> Regards,
>
>
> On Sunday, November 30, 2014 3:57 PM, Mostafa Eletriby <
> dmarc-noreply_at_freelists.org> wrote:
>
>
> Hello,
> I tried those statements and restarted database. I am checking now.
> Database version 11.2.0.2 Enterprise edition
>
> Alter system set events '10513 trace name context forever, level 2';
> ALTER SYSTEM SET EVENTS '10231 trace name context forever, level 10';
>
>
>
> On Sunday, November 30, 2014 3:37 PM, Maclean Liu <maclean_007_at_163.com>
> wrote:
>
>
> Mostafa,
>
> event 10513 level 2 may help you keep database open temporarily .
> You can skip the corrupted block by setting event 10231 level 10 , if
> you the data is really not important .
>
>
>
> -ML
> --
>
> Maclean Liu
> Senior Director Product Management
> ParnassusData Software ,Inc. http://www.parnassusdata.com/
> Phone : (+86) 400-690-3643 ; Mobile : (+86) 13764045638
> My Blog: http://askmaclean.com/
> 4/F, No.733 Gaoping Road Shanghai , China
> zip code: 200436
>
> On Sun, Nov 30, 2014 at 9:16 PM, Mostafa Eletriby <
> dmarc-noreply_at_freelists.org> wrote:
>
> Hello Uwe,
> Yes you are right , this block is not in the online redo logs anymore.
> Also the data in this database is not important to me, the most important
> thing is just the instance to be running.
> The database could be online when I startup but after a while it goes down.
> I tried to export the database but gave me errors due to block corruption
> , I am working at these errors.
>
> Thanks so much
> Regards,
>
>
> On Sunday, November 30, 2014 3:01 PM, Uwe Küchler <uwe_at_kuechler.org>
> wrote:
>
>
> Mostafa,
>
> If this block was corrupted BEFORE you switched archive log mode on and
> recovery info for this block is not in the online redo logs anymore (which
> I guess is the case), then this block is lost.
>
> Not meaning to be rude, but I suppose the data within this database is of
> low importance to you / your organization, because otherwise you'd have had
> this DB backed up properly beforehand.
>
> Are you able to get the DB online? Then do an export of the schema(s) that
> matter to you instantly! Then try to find out more about the ORA-600 and
> then start with a new DB where you re-import your data.
> If the ORA-1124 persists,
>
> 1. shutdown immediate,
> 2. startup mount and
> 3. recover database;
>
> If it still persists, file an SR with Oracle.
>
> Regards,
> Uwe
>
> On 30.11.2014 13:38, Mostafa Eletriby (Redacted sender m_etrib_at_yahoo.com
> for DMARC) wrote:
>
> Hello Uwe,
> Thanks for reply.
> I will try ORA-00600-Troubleshooting Tool
> <https://support.oracle.com/epmos/faces/ui/gr/GrHome.jspx?domainId=ORA600>
>
> I tried to recover database because I had a block corruption shown at the
> alert log file.
> But I couldn't upload log files here because uploading contents is not
> allowed at that moment.
> Regards,
>
>
> On Sunday, November 30, 2014 2:29 PM, Uwe Küchler <uwe_at_kuechler.org>
> <uwe_at_kuechler.org> wrote:
>
>
> Mostafa,
>
> as for the ORA-600 you should try the
> “ORA-00600-Troubleshooting Tool
> <https://support.oracle.com/epmos/faces/ui/gr/GrHome.jspx?domainId=ORA600>
> ”
> on My Oracle Support for a suggestion. Upload the corresponding trace file
> or an IPS package and see what the tool comes up with.
>
> As for the recovery error, you didn't provide us with much information.
> Why did you have to "recover database" in the first place? Could it be that
> your database is already open instead of just mounted?
>
> Regards,
> Uwe
> ---
> http://oraculix.com/
>
> On 30.11.2014 11:55, Mostafa Eletriby (Redacted sender m_etrib_at_yahoo.com
> for DMARC) wrote:
>
> Hello DBAs,
> I have a problem regarding Ora-600 error at Alert log file.
> It appears regularly at alert log file and stops database and needs to
> re-open database.
> Please tell me which procedures that I should follow in order to solve the
> problem.
>
> Database has no previous backup taken.
> Database was in no archive mode before problem happened but now it is
> switched to archive log mode
>
> ------------------------------------
> SQL> recover database;
> ORA-00283: recovery session canceled due to errors
> ORA-01124: cannot recover data file 1 - file is in use or recovery
> ORA-01110: data file 1: '/oraData/cdsdb/system01.dbf'
>
>
> Please advice me.
>
> Thanks
> Regards,
>
>
>
>
>
>
>
>
>
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 30 2014 - 15:22:39 CET

Original text of this message