Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [07-2007 Date Index] [Date Next] || [Thread Prev] [07-2007 Thread Index] [Thread Next]

RE: Shutdown Abort

  • From: "Randy Johnson" <randyjo@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 2 Jul 2007 23:58:42 -0500
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@xxxxxxxxxxx"randy.johnson@xxxxxxxxxxx 

 

   _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: Monday, July 02, 2007 2:07 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx

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
 




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.