RE: Query Database while shutdown in progress
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: <randyjo@xxxxxxxxxxxxx>, <ian@xxxxxxxxxxxxxxxxx>, "'Jared Still'" <jkstill@xxxxxxxxx>, <Joel.Patterson@xxxxxxxxxxx>
- Date: Wed, 27 Jun 2007 19:27:01 -0600
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@xxxxxxxxxxxxx]
Sent: Wednesday, June 27, 2007 7:22 PM
To: ian@xxxxxxxxxxxxxxxxx; robertgfreeman@xxxxxxxxx; 'Jared Still';
Joel.Patterson@xxxxxxxxxxx
Cc: andrew.kerber@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Query Database while shutdown in progress
Ever hear of RAC? ;-)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of MacGregor, Ian A.
Sent: Wednesday, June 27, 2007 5:16 PM
To: robertgfreeman@xxxxxxxxx; Jared Still; Joel.Patterson@xxxxxxxxxxx
Cc: andrew.kerber@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Robert Freeman
Sent: Wednesday, June 27, 2007 1:55 PM
To: Jared Still; Joel.Patterson@xxxxxxxxxxx
Cc: andrew.kerber@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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
--
//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
