>> I had once a problem with system transactions >> (in SYSTEM RBS) that got stuck.
Good questions, but I don't know for sure. I guess I have been *lucky* with my UNDO-RBS corruption/loss...it has always been not non-SYSTEM segments. I would think my procedures would work, but I guess you would need an additional SYSTEM UNDO/RBS segment before trying to kill/drop the old one? With non-SYSTEM UNDO/RBS segments I was just whipping them all out, but allways had a SYSTEM UNDO/RBS segments available.
If you try it let us know.
Chris Marquez Oracle DBA M -(703)507-1421 cmarquez@(protected)
-- --Original Message-- -- From: Alex Gorbachev [mailto:gorbyx@(protected)] Sent: Thu 10/27/2005 2:09 AM To: Marquez, Chris Cc: oracle-l@(protected) Subject: Re: Trying to drop old undo tablespace that needs recovery
Hi Chris,
I had once a problem with system transactions (in SYSTEM RBS) that got stuck. SMON was core dumping all the time and complaining. The database was working like that for few months (test system but important one) excluding certain functionality (this is where dictionary was affected I guess). Do you think that can be rocovered as well? In fact, I still have it - just finished migration to a new database and about to give away this old "broken" DB. Would be interesting to try to recover it now.
Cheers, Alex
2005/10/27, Marquez, Chris <cmarquez@(protected)>: > > > > Mark, > > Your problem is likely the oracle (transactions) are still holing on to and > UNDO segment and oracle want to right itself. > > >>They [offline undo segments] don't show a status of needing recovery. > > I have not been in the exact position, but in a very similar one...sadly > several times. > I would like to see more of the ORA-00600 (See ORA-00600.ora-code.com) or other ORA- error details. > > I have my own notes titled; > Drop Rollback or UNDO Tablspace With Active / Corrupt / "NEEDS RECOVERY" > Segments > I will send them to you directly. > > But in a basically it goes like this; > <skip>
-- Best regards, Alex Gorbachev
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7233.28"> <TITLE>RE: Trying to drop old undo tablespace that needs recovery</TITLE> </HEAD> <BODY> <!-- Converted from text/plain format -->
<P><FONT SIZE=2>Alex,<BR> <BR> >> I had once a problem with system transactions<BR> >> (in SYSTEM RBS) that got stuck.<BR> <BR> Good questions, but I don't know for sure.<BR> I guess I have been *lucky* with my UNDO-RBS corruption/loss...it has always been not non-SYSTEM segments.<BR> I would think my procedures would work, but I guess you would need an additional SYSTEM UNDO/RBS segment before trying to kill/drop the old one?  ; With non-SYSTEM UNDO/RBS segments I was just whipping them all out, but allways had a SYSTEM UNDO/RBS segments available.<BR> <BR> If you try it let us know.<BR> <BR> Chris Marquez<BR> Oracle DBA<BR> M -(703)507-1421<BR> cmarquez@(protected)<BR> <BR> <BR> -- --Original Message-- --<BR> From: Alex Gorbachev [<A HREF="mailto:gorbyx@(protected)">mailto:gorbyx@(protected) </A>]<BR> Sent: Thu 10/27/2005 2:09 AM<BR> To: Marquez, Chris<BR> Cc: oracle-l@(protected)<BR> Subject: Re: Trying to drop old undo tablespace that needs recovery<BR> <BR> Hi Chris,<BR> <BR> I had once a problem with system transactions (in SYSTEM RBS) that got<BR> stuck. SMON was core dumping all the time and complaining. The<BR> database was working like that for few months (test system but<BR> important one) excluding certain functionality (this is where<BR> dictionary was affected I guess).<BR> Do you think that can be rocovered as well? In fact, I still have it -<BR> just finished migration to a new database and about to give away this<BR> old "broken" DB. Would be interesting to try to recover it now.<BR> <BR> Cheers,<BR> Alex<BR> <BR> 2005/10/27, Marquez, Chris <cmarquez@(protected)>:<BR> ><BR> ><BR> ><BR> > Mark,<BR> ><BR> > Your problem is likely the oracle (transactions) are still holing on to and<BR> > UNDO segment and oracle want to right itself.<BR> ><BR> > >>They [offline undo segments] don't show a status of needing recovery.<BR> ><BR> > I have not been in the exact position, but in a very similar one...sadly <BR> > several times.<BR> > I would like to see more of the ORA-00600 (See ORA-00600.ora-code.com) or other ORA- error details.<BR> ><BR> > I have my own notes titled;<BR> > Drop Rollback or UNDO Tablspace With Active / Corrupt / "NEEDS RECOVERY"<BR> > Segments<BR> > I will send them to you directly.<BR> ><BR> > But in a basically it goes like this;<BR> ><BR> <skip><BR> <BR> --<BR> Best regards,<BR> Alex Gorbachev<BR> <BR> </FONT> </P>
