Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

RE: Shutdown Abort

From: <Joel.Patterson@xxxxxxxxxxx>
To: <randyjo@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 3 Jul 2007 11:44:52 -0400

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

References:

RE: Shutdown Abort
From: Randy Johnson

RE: Shutdown Abort

Other related posts: