Hmmm, True, but it was just an FYI anyway. The controlled test would need to be doing something like this database was - which was testing. Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Randy Johnson Sent: Tuesday, July 03, 2007 9:08 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Shutdown Abort With all due respect this was not a controlled test. So I'd be carefull not to assume it was caused by the abort. -Randy Randy Johnson Sr. Technical Consultant Enkitec, LLP Office ..... 817-255-3580 Mobile .... 817-564-6583 Email ..... randy.johnson@xxxxxxxxxxx ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joel.Patterson@xxxxxxxxxxx Sent: Tuesday, July 03, 2007 7:11 AM To: m.haddon@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Shutdown Abort Well... I think this goes towards the conversation about whether it is safe or not. No data is lost with TEMP... but others brought up the issue that the database could have been writing blocks to the datafiles just at that moment. (or tempfile)? I don't believe data would be lost... (what if log buffer was being flushed to redo log)? ... This can be discussed separately, but my point goes to the argument that it saves time... which was what started the thread. Does it save time, if the tempfile fails verification tests... or if a datafile needs recovery (aside from the fact that recovery is implicit with shutdown abort). Perhaps if you already had the drop/create tempfile statements ready... you might say that in your particular situation, it saves time If you manually shutdown startup. But it doesn't look like a particularly best practices type of thing to automate reliably, (meaning you can sleep through it). .... I'm not drawing conclusions adamantly, but just pointing out what actually happened. (It was a test environment). Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 ________________________________ From: Michael Haddon [mailto:m.haddon@xxxxxxxxx] Sent: Tuesday, July 03, 2007 1:46 AM To: Patterson, Joel; Oracle-L@Freelists Subject: Re: Shutdown Abort Hmmm.. I would be curious about what other data might be in a questionable state,... Joel.Patterson@xxxxxxxxxxx wrote: 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