From oracle-l-bounce@freelists.org Tue Mar 2 09:50:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i22FoZk26979 for ; Tue, 2 Mar 2004 09:50:35 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i22FoZo26974 for ; Tue, 2 Mar 2004 09:50:35 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09308395485; Tue, 2 Mar 2004 10:50:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 02 Mar 2004 10:48:44 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from nwkea-mail-1.sun.com (nwkea-mail-1.sun.com [192.18.42.13]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 39EA0395460 for ; Tue, 2 Mar 2004 10:48:37 -0500 (EST) Received: from phys-giza-1 ([129.147.4.102]) by nwkea-mail-1.sun.com (8.12.10/8.12.9) with ESMTP id i22FqF0J014977 for ; Tue, 2 Mar 2004 07:52:15 -0800 (PST) Received: from sun.com (sr1-ubrm-05.Central.Sun.COM [129.147.4.11]) by giza-mail1.Central.Sun.COM (iPlanet Messaging Server 5.2 HotFix 1.16 (built May 14 2003)) with ESMTP id <0HTY006VJHF38D@giza-mail1.Central.Sun.COM> for oracle-l@freelists.org; Tue, 02 Mar 2004 08:52:15 -0700 (MST) Date: Tue, 02 Mar 2004 08:52:14 -0700 From: Daniel Fink Subject: Re: Bug number for undo tablespace problem To: oracle-l@freelists.org Message-id: <4044ADAE.4E08D6D8@sun.com> MIME-version: 1.0 X-Mailer: Mozilla 4.79C-CCK-MCD [en] (X11; U; SunOS 5.9 sun4u) Content-Type: multipart/alternative; boundary=------------3CAC576FAB8656A6857FBFFF X-Accept-Language: en References: X-archive-position: 23 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Daniel.Fink@Sun.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --------------3CAC576FAB8656A6857FBFFF Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit IIRC, there was a bug related to a shutdown abort during a kernel transaction that would cause corruption. I don't know the bug, but the additional info may help. One of the 'bugs' that was often discussed had to do with people switching between manual (rbs) and automatic undo after shutting down the database in an inconsistent mode (abort). Not a bug, but PEBCAK. Daniel "Adams, Matthew (GE Consumer & Industrial)" wrote: > > > Anybody remember to bug number for the problem > in early versions of Oracle9 where using undo > tablespaces could cause database corruptions. > (or is my memory playing tricks on me again) > > A brief search on metalink is not giving the > answer, but I'm still searching. > > Matt > > ---- > Matt Adams - GE Appliances - matt.adams@appl.ge.com > Nobody loves me but my mother, > and she could be jivin' too. > B. B. King --------------3CAC576FAB8656A6857FBFFF Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit IIRC, there was a bug related to a shutdown abort during a kernel transaction that would cause corruption. I don't know the bug, but the additional info may help. One of the 'bugs' that was often discussed had to do with people switching between manual (rbs) and automatic undo after shutting down the database in an inconsistent mode (abort). Not a bug, but PEBCAK.

Daniel
 

"Adams, Matthew (GE Consumer & Industrial)" wrote:

 

Anybody remember to bug number for the problem
in early versions of Oracle9 where using undo
tablespaces could cause database corruptions.
(or is my memory playing tricks on me again)

A brief search on metalink is not giving the
answer, but I'm still searching.

Matt

----
Matt Adams - GE Appliances - matt.adams@appl.ge.com
Nobody loves me but my mother,
  and she could be jivin' too.
           B. B. King

--------------3CAC576FAB8656A6857FBFFF-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------