Re: Lost ofall redo logs
Hi People I don't think that i need to update my CV, since I don't administer the database in subject and that am trying to solve the an unhappy customer's problem. I had already researched and tried almost everything that you suggested me and what really solved went use to suggestion of the not documented parameter (_allow_resetlogs_corruption), then do a full export, then recreate the database and do a full import. I think that this list is wonderful, whenever I had a problem and I didn't get to solve I asked help here and I went very well assisted, much better than the oracle support. Thank you! ::::::::: Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Bra5il [EMAIL PROTECTED]http://www.upf.br : -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Lost ofall redo logs
Nop, all redo logs gone away... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 5:43 PM > What about mirrored redo group members? > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, September 18, 2002 4:30 PM > > > Hi people... > > What to do if I have LOST ALL REDO LOGS and i don´t have any backup? > > Thanks in advance! > > : > Gilberto Gampert Universidade de Passo Fundo > Administrador de Banco de Dados Passo Fundo - RS - Bra5il > [EMAIL PROTECTED]http://www.upf.br > ::::: > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gilberto Gampert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Igor Neyman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Lost ofall redo logs
There is a way to reconstruct this files? or startup and reconstruct ? The database is in noarchivelog... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 5:30 PM > Hi people... > > What to do if I have LOST ALL REDO LOGS and i don´t have any backup? > > Thanks in advance! > > ::::::::: > Gilberto Gampert Universidade de Passo Fundo > Administrador de Banco de Dados Passo Fundo - RS - Bra5il > [EMAIL PROTECTED]http://www.upf.br > : > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gilberto Gampert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Lost ofall redo logs
Hi people... What to do if I have LOST ALL REDO LOGS and i don´t have any backup? Thanks in advance! : Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Bra5il [EMAIL PROTECTED]http://www.upf.br : -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: View v_$session
Yep, i did! - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, May 18, 2001 3:15 PM > Did you run catproc? Just a thotrbg > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 17, 2001 4:31 PM > > > > Hi guys! > > > > Since the upgrade of my Oracle server to the version 8.1.6 (I applied all > > the patches) and the rebuild of the clients applications with the > libraries > > from the same version, the column PROGRAM of the view v_$session is empty. > > If the application is using the old libs, the program apears in the view. > > Does anybody know the solution? What to do to see the program that is > > running? > > > > I thank in advance!!! > > > > --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- > > Gilberto Gampert Universidade de Passo Fundo > > Administrador de Banco de Dados Passo Fundo - RS - Brazil > > [EMAIL PROTECTED] http://www.upf.tche.br > > --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Gilberto Gampert > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
View v_$session
Hi guys! Since the upgrade of my Oracle server to the version 8.1.6 (I applied all the patches) and the rebuild of the clients applications with the libraries from the same version, the column PROGRAM of the view v_$session is empty. If the application is using the old libs, the program apears in the view. Does anybody know the solution? What to do to see the program that is running? I thank in advance!!! --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Brazil [EMAIL PROTECTED] http://www.upf.tche.br --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent - Migration
Thanks for all!! I applied the patch 8.1.6.3.0 and everything was right! Again, thank you! --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Brazil [EMAIL PROTECTED] http://www.upf.tche.br --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Urgent - Migration
Hello People! I migrate the Oracle 7.3.4.5 to Oracle 8.1.6.0.0, in the following way: 1) I exported the data 2) I removed off Oracle 7 3) I installed Oracle 8 4) I imported the data The problem is that began to appear the following error in the alert.log: --- Mon Apr 16 15:43:19 2001 Errors in file /u01/app/oracle/admin/sun/bdump/sun_s001_1065.trc: ORA-07445: exception found: core dump[kxscdv()+180] [SIGSEGV] [Address not mapped to object] [4] [] [] Mon Apr 16 15:43:54 2001 found dead multi-threaded server 'S001', pid = (13, 2) --- and in the client applications appears: ORA-03113 end-of-file on communication channel. Does anybody can help me? Platform: SUN Enterprise 3000 with 1.5Gb RAM Solaris 2.6 --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Brazil [EMAIL PROTECTED] http://www.upf.tche.br --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).