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 ..... 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: 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,...
HYPERLINK "mailto:Joel.Patterson@xxxxxxxxxxx"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
HYPERLINK "mailto:joel.patterson@xxxxxxxxxxx"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
