RE: Query Database while shutdown in progress

And I really meant 5 nines, not 9.... :-) Of course, that gives me all of about 31 seconds...

RF

Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! Sig V1.1

-----Original Message-----

From: Randy Johnson [mailto:randyjo_at_sbcglobal.net] Sent: Wednesday, June 27, 2007 7:22 PM
To: ian_at_slac.stanford.edu; robertgfreeman_at_yahoo.com; 'Jared Still'; Joel.Patterson_at_crowley.com
Cc: andrew.kerber_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Query Database while shutdown in progress

Ever hear of RAC? ;-)

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of MacGregor, Ian A.
Sent: Wednesday, June 27, 2007 5:16 PM
To: robertgfreeman_at_yahoo.com; Jared Still; Joel.Patterson_at_crowley.com Cc: andrew.kerber_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Query Database while shutdown in progress

 You won't make 9 nines with shutdown abort

Seconds in a year

select 365 *24 *60 * 60 from dual;

365*24*60*60

    31536000

Amount of downtime allowed for 9 nines

 1* select 31536000 - (31536000 * .999999999) from dual SQL> / 31536000-(31536000*.999999999)

                       .031536

And remember it's supposed to include scheudled maintenance down times.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Freeman
Sent: Wednesday, June 27, 2007 1:55 PM
To: Jared Still; Joel.Patterson_at_crowley.com Cc: andrew.kerber_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Query Database while shutdown in progress

And there is a *very* good point made in that page. If you work in an environment where 9 nines is the target, shutdown a
--

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

No virus found in this incoming message. Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007 11:54 PM

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007 11:54 PM

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 27 2007 - 20:27:01 CDT