Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id AF59E1960356 for ; Sun, 30 Nov 2014 14:18:19 +0100 (CET) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Sun, 30 Nov 2014 14:18:19 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 297C633063; Sun, 30 Nov 2014 08:18:19 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1417353499; bh=R1MxHeSRhoy6cmIB+z/9tCcC/dy68BmCrCs7+sn/Qic=; h=Date:From:To:Message-ID:In-Reply-To:References:Subject: MIME-Version:Content-Type:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=iECazWxTgaMQIi2JsNcLk7h3rKZvaSwUSVaGKLz3FlaFcz5xERyqC1RNodXQw/UHF ZYTfBZqPoLmI+c6ZLQEAiZfqYqMLa4Ycy4YIh2/gfjfOZH+jP2l9+8jtRAYWswRyyY TNNk0hhS81lFEesa2VaXmx5XvuOb8hp+B+r1g2E0= X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id g+L5aZfSm0XS; Sun, 30 Nov 2014 08:18:19 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0892133049; Sun, 30 Nov 2014 08:18:03 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1417353498; bh=R1MxHeSRhoy6cmIB+z/9tCcC/dy68BmCrCs7+sn/Qic=; h=Date:From:To:Message-ID:In-Reply-To:References:Subject: MIME-Version:Content-Type:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=KonlWnHKIAK4UhC7/0ujEn/hDI48wFI2NbiFuKpc0qi/uC/ivXgUaFqyNbva5cQD8 xydAhLtURSuJonyAvg81Tvs0lPTQ7rO4aMEkWxmWs3pOKMzN6ESG6BRcC7FItxvFgG yivYiqF/DdN6HE3n9Eqp3qAGjiIGZdxH3+NrPCGM= Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 30 Nov 2014 08:16:42 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B755E32FC7 for ; Sun, 30 Nov 2014 08:16:41 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key; insecure key) header.i=@yahoo.com; dkim-adsp=pass Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id tdHPsluCFAiN for ; Sun, 30 Nov 2014 08:16:41 -0500 (EST) Received: from nm25-vm1.bullet.mail.bf1.yahoo.com (nm25-vm1.bullet.mail.bf1.yahoo.com [98.139.212.155]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8488E32FB4 for ; Sun, 30 Nov 2014 08:16:23 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1417353383; bh=S/OK0+GrckXo7qnSybZVuj978YjBYvfEZNZVC8ZhoXE=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=YMRVH+fgJ1uViAUrIAlOoujvFP+rZsJWtcZQr3bC3Fy38ylvG+1sspuTQjaukAx8JZ1ldDxS+fGdDfPgROPFIU4o+5KGnhr7AuBeXlj86TWKs68i6NsJvHmzkZFtI/rfiTzaXXkjzSTZ5EEJy2loTDsKzuSIU2FGyzc0lVtIwjywdEwLM2oh0iUHVRM0t2H01NIWHWWReeexzRjDeDMTyokfBabYt3cXl5yM9r4pQULVMrQ8QLhLxhGyYeqmQHt4+IBUl1bDNX5GaZMNq7aT67CATYN1eV52erfQnfqBA1igswbsSum2/3qHtrsiRaqqn7+tGneSYDvs0s8ZpSDUgA== DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s2048; d=yahoo.com; b=DoYzcYKe2JvEDmDYpgNoZ09szOK4IsgocI7jPCSmX24pMtD/VbYp0KnnYbwO2ZMgWg6p7qNKN/MrcnL74C3RCXc/OOGJaZiYN4qiZR+nQPn8H4wEtMlN92OpiBpI5Nj87D9EFowDoGj4a+i/1Jjj6QKFHDVO/N6sLoFHZjY8lG+rF5da+Bw5Gt4YSfEfwgQ/Npidm0FtO6N3OgXLKaJZxTE69gIEmcRELYaek5AqJKhiyBS1/QQ94y9mccnBdobJ9rCkSQ7cfvdA+VWqBa7UMhIDQdW+0H8EA/5girzhz3FTYHQ+z9eimBt5I/HxbKEFeHzAFAUSbe3ryNfYWt8rJw==; Received: from [66.196.81.173] by nm25.bullet.mail.bf1.yahoo.com with NNFMP; 30 Nov 2014 13:16:23 -0000 Received: from [98.139.215.250] by tm19.bullet.mail.bf1.yahoo.com with NNFMP; 30 Nov 2014 13:16:23 -0000 Received: from [127.0.0.1] by omp1063.mail.bf1.yahoo.com with NNFMP; 30 Nov 2014 13:16:23 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 121745.24637.bm@omp1063.mail.bf1.yahoo.com X-YMail-OSG: YdJNUTMVM1nsqv.BamP5N3UTbN3Zaljiy.7vD1ZJW05QlP.2vYmU5qt2qY3Fyj4 TIh0j7O_lzMUslFt_BCJG6yyvzgITI507V1SYyecvo.IEJ2SZGNK.4bge.bILG7_86qk9e.TuTk_ KefOm3KGpkxHqsDBV3NQgxlM5yRiNJeMxJp3zbNS.1pXYADfUY86Z9_5CqU62dI4Hm3hd.hj80E1 hZTcxQaqM.GLCWP2YpCYWQ2Vtoj9Zxcxuth27UZ0l5yES1rKi9VhWPMEgL8l6.ktRnusnfOa2Lkb c_hxDRm84znuiFP4gzFRpHhAy1ctuR3lI8.YH.v.NTSNdY2kKYAKzJP4TkCly47ylDslolVFezVW O7TksHmEJcAx.c23_T0bVoywKtRaZQ6DT6GCuSGakUYijr3KUTl6L7w8OdcURTikx0hrIdB5Bz1V Kb0HgbirKXbdokkZWzAWAWeMinUW38UTx7Ysq5SHwyuMT3rVb.dW3d.e3pqbzOPFKrw9gAjKCx9h 9CBJPBUE3PoQzVj.U0Xbovu9MBu3GxVUmHo7Nt2VvSERcVd.YBIAuENAEbVIHhEvMuVcbjuwzpK2 JHGtOkka7ZXW9sailqvhS.1RXQyrvBLfotfpf7KedJB6bCzNhqS7_MGmRKYCtCdLcZzStFzJS8CU 0zrof0qi5usWB Received: by 76.13.27.50; Sun, 30 Nov 2014 13:16:22 +0000 Date: Sun, 30 Nov 2014 13:16:22 +0000 From: "Mostafa Eletriby" (Redacted sender "m_etrib@yahoo.com" for DMARC) To: "oracle-l@freelists.org" Message-ID: <1006872795.2724814.1417353379841.JavaMail.yahoo@jws10684.mail.bf1.yahoo.com> In-Reply-To: <547B14E3.8010005@kuechler.org> References: <547B14E3.8010005@kuechler.org> Subject: Re: ORA-00600: internal error code MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2724813_1785591836.1417353379830" X-archive-position: 57628 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: dmarc-noreply@freelists.org Precedence: normal Reply-To: dmarc-noreply@freelists.org List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Orig-Date: Sun, 30 Nov 2014 13:16:19 +0000 (UTC) ------=_Part_2724813_1785591836.1417353379830 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello Uwe,Yes you are right ,=C2=A0this block is not in the online redo log= s anymore.=C2=A0Also 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 t= he database but gave me errors due to block corruption , I am working at th= ese errors. Thanks so muchRegards,=20 On Sunday, November 30, 2014 3:01 PM, Uwe K=C3=BCchler wrote: =20 Mostafa, =20 If this block was corrupted BEFORE you switched archive log mode on and re= covery info for this block is not in the online redo logs anymore (which I = guess is the case), then this block is lost. =20 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. =20 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 t= hen start with a new DB where you re-import your data. If the ORA-1124 persists,=20 =20 - shutdown immediate, =20 =20 - startup mount and =20 =20 - recover database; If it still persists, file an SR with Oracle. =20 Regards, Uwe =20 On 30.11.2014 13:38, Mostafa Eletriby (Redacted sender m_etrib@yahoo.com f= or DMARC) wrote: =20 Hello=C2=A0Uwe, Thanks for reply. I will try=C2=A0ORA-00600-Troubleshooti= ng Tool=C2=A0 I tried to recover database because I had a block corruption = shown at the alert log file.=C2=A0 But I couldn't upload log files here bec= ause uploading contents is not allowed at that moment. Regards,=20 =20 On Sunday, November 30, 2014 2:29 PM, Uwe K=C3=BCchler wrote: =20 =20 Mostafa, =20 as for the ORA-600 you should try the =C2=A0=E2=80=9CORA-00600-Troubleshooting Tool=E2=80=9D on My Oracle Support for a suggestion. Upload the corresponding trace file= or an IPS package and see what the tool comes up with. =20 As for the recovery error, you didn't provide us with much information. Wh= y did you have to "recover database" in the first place? Could it be that y= our database is already open instead of just mounted? =20 Regards, Uwe --- http://oraculix.com/ =20 On 30.11.2014 11:55, Mostafa Eletriby (Redacted sender m_etrib@yahoo.com f= or DMARC) wrote: =20 Hello DBAs, I have a problem regarding Ora-600 error at Alert log file. I= t appears regularly at alert log file and stops database and needs to re-op= en database. Please tell me which procedures that I should follow in order = to solve the problem.=20 Database has no previous backup taken. Database was =C2=A0in no archive m= ode before problem happened but now it is switched to archive log mode=20 ------------------------------------ SQL> recover database; ORA-00283: re= covery 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/syste= m01.dbf'=20 =20 Please advice me.=20 Thanks Regards,=20 =20 =20 =20 =20 =20 =20 =20 =20 ------=_Part_2724813_1785591836.1417353379830 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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 error= s due to block corruption , I am working at these errors.

Thanks so much
Regards,


On Sunday, November 30, 2014 3:01 P= M, Uwe K=C3=BCchler <uwe@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@yahoo.com for DMARC) wrote:
=
Hello Uwe,
Thanks for reply.
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=C3=BCchler <uwe@kuechler.org> wrote:


Mostafa,
as for the ORA-600 you should try the
 =E2=80=9CORA-= 00600-Troubleshooting Tool=E2=80=9D
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
---
ht= tp://oraculix.com/

On 30.11.2014 11:55, Mostafa Eletriby (Redacted sender m_etrib@yahoo.com for DMARC) wrote:
Hello DBAs,
I have a problem regarding Ora-= 600 error at Alert log file.
It appears regularly at alert l= og file and stops database and needs to re-open database.
Please tell me whic= h procedures that I should follow in order to solve the problem.

Database has no previous backup taken.
Database was  in no archiv= e 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,








------=_Part_2724813_1785591836.1417353379830-- -- http://www.freelists.org/webpage/oracle-l