Re: problem getting rid of an undo tablespace

From: david wendelken <davewendelken_at_earthlink.net>
Date: Tue, 16 Mar 2004 12:04:12 -0800 (PST)
Message-ID: <5214091.1079467452536.JavaMail.root@beaker.psp.pas.earthlink.net>

E\oraXXX\init\initXXX.ora is just a directory and file name, you need to substitute the correct filename and location for your installation.

-----Original Message-----
From: Mladen Gogala <mladen_at_wangtrading.com> Sent: Mar 16, 2004 11:36 AM
To: oracle-l_at_freelists.org
Subject: Re: problem getting rid of an undo tablespace

It doesn't work.
[root_at_tux925 root]#
[root_at_tux925 root]# su - oracle
-bash-2.05b$
-bash-2.05b$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 16 14:32:53 2004

Connected to an idle instance.

SQL> startup pfile=E:\oraXXX\init\initXXX.ora; LRM-00109: could not open parameter file 'E:oraXXXinitinitXXX.ora' ORA-01078: failure in processing system parameters SQL> I have a slight suspicion that the "bash" thing is the problem. It doesn't recognize anything like "E:\"? Should I get rid of my OS and switch to the quasi-OS that does recognize it?

On 03/16/2004 01:59:29 PM, Juan Cachito Reyes Pacheco wrote:
> Here is the process to recreate a too bin undo tablespace, it will help to
> delete the one you have.
>
>
> connect SYS/SYS_at_XXX as SYSDBA;
> shutdown;
> connect SYS/SYS_at_XXX as SYSDBA;
> startup pfile=E:\oraXXX\init\initXXX.ora;
>
> CREATE UNDO TABLESPACE TBL_UNDOS DATAFILE 'E:\oraXXX\datafiles\dfl_undoXXX'
> SIZE 50M
> REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
> ALTER SYSTEM SET UNDO_TABLESPACE = TBL_UNDOS;
> ALTER TABLESPACE "TBL_UNDO" OFFLINE NORMAL;
>
> DROP TABLESPACE TBL_UNDO
> INCLUDING CONTENTS AND DATAFILES;
>
> CREATE UNDO TABLESPACE TBL_UNDO DATAFILE 'E:\oraXXX\datafiles\dfl_undo_XXX'
> SIZE 50M
> REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
> ALTER SYSTEM SET UNDO_TABLESPACE = TBL_UNDO;
>
> DROP TABLESPACE TBL_UNDOS
> INCLUDING CONTENTS AND DATAFILES;
>
> ALTER DATABASE DATAFILE 'E:\ORAXXX\DATAFILES\DFL_UNDO_XXX' AUTOEXTEND ON
> MAXSIZE UNLIMITED;
>
>
>
> ----- Original Message -----
> From: "david wendelken" <davewendelken_at_earthlink.net>
> To: <oracle-l_at_freelists.org>
> Sent: Tuesday, March 16, 2004 2:30 PM
> Subject: Re: problem getting rid of an undo tablespace
>
>
> >
> > I have a problem with one of the files in my undo tablepace.
> >
> > Given that there are not any transactions to undo, it seemed simplest to
> just drop the file.
> > But I haven't been able to get the database to let me do that.
> >
> > So, I created a 2nd undo tablespace with the intention of taking the first
> off line and then dropping it.
> > But I haven't been able to get the database to let me take it off line.
> >
> > I found a parameter in my spfile called "undo_tablespace" which was set to
> the old tablespace.
> > I shut down the database, changed the entry to point to the new
> tablespace, but the database would not open up.
> >
> > Any ideas on how to clear out the corrupted undo tablespace file?
> >
> > Thanks in advance!
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_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
> > -----------------------------------------------------------------
> >
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_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
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_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
-----------------------------------------------------------------

Received on Tue Mar 16 2004 - 14:00:43 CST