RE: Shutdown Abort

From: Randy Johnson <randyjo_at_sbcglobal.net>
Date: Mon, 2 Jul 2007 23:58:42 -0500
Message-ID: <001f01c7bd2e$d4b4ea40$6701a8c0@scraunch>

The TEMP tablespace datafile (tempfile rather) is dropped and recreated on every shutdown/restart anyway.  

    -Randy      

Randy Johnson
Sr. Technical Consultant
Enkitec, LLP

Office ..... 817-255-3580
Mobile .... 817-564-6583
Email ..... HYPERLINK

"mailto:randy.johnson_at_enkitec.com"randy.johnson_at_enkitec.com  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel.Patterson_at_crowley.com
Sent: Monday, July 02, 2007 2:07 PM
To: oracle-l_at_freelists.org
Subject: Shutdown Abort

Update FYI:

I just did a shutdown abort on 10.2.0.1 and got:

ORA-01187: cannot read from file 201 because it failed verification tests.

Had to drop and re-create the TEMP tablespace….

Joel Patterson

Database Administrator

joel.patterson_at_crowley.com

x72546

904 727-2546

No virus found in this incoming message. Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.14/883 - Release Date: 7/1/2007 12:19 PM

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.14/883 - Release Date: 7/1/2007 12:19 PM  

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 02 2007 - 23:58:42 CDT