Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: High-availability database question !!!!

Re: High-availability database question !!!!

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 27 Jun 2003 08:47:03 -0700
Message-ID: <F001.005BB1C6.20030627080447@fatcity.com>



Yup.  I work for Chartered Semiconductor Manufacturing and we use
Promis in the manufacturing
floor in all the current fabs.  CIM uses a number of custom-built
Oracle databases.
And Corporate systems are all on Oracle.
The newest fab, coming up soon, may not be using Promis [information
confidential ;> ]
Regards
Hemant
At 10:34 PM 26-06-03 -0800, you wrote:
You mean the Danish Promis system?
You're running that?
Hemant K Chitale wrote:

The "That might come as a surprise to some people, but there's
basically no 25/8/370 availability with Oracle unless you either specify
downtime as something else or don't patch/upgrade at all." 
doesn't cut ice [I think I might have mixed metaphors here] with
damagement.
My 8iOPS to 9iRAC upgrade had been in the planning stages for more than a
year, never getting the 4 hours downtime requested.
Finally, the upgrade was scheduled for 10am to 2pm on a Wednesday.
Guess what ?   Tuesday night, 9pm I get a call "the Promis
system is down, manufacturing is down".  Can you come in
and
quickly upgrade the Oracle database to 9iRAC tonight, like, NOW ?  I
did do it in 3.5 hours !
Hemant
At 06:59 AM 25-06-03 -0800, you wrote:
1. RAC can duplicate your
instances/nodes. But you still have only one database.
2. One database means un-availability whenever you have to apply a patch
or upgrade the database. No online patches available. No rolling
upgrades.
3. Dataguard needs to have exactly the same version (down to patch level)
on the two (or more) databases. So that just means two databases down if
you have to patch or upgrade. That might come as a surprise to some
people, but there's basically no 25/8/370 availability with Oracle unless
you either specify downtime as something else or don't patch/upgrade at
all.
4. Logical stuff like replication, logical Dataguard, Shareplex from
Quest and others can get around the
"everyhing-has-to-be-the-same-version" by using logical
replication of some sort - some faster, some slower.
Mogens
Jackson Dumas wrote:

Goodday all

We have cutomer who is having a database which should be available
24x7.
Now we can't get even a maintenance time to do the database. We tried
on several occasion but nothing happens.
Now they want us to provide them with a solution to be able to work on
"another database" if we need to do maintenance. Could you
guys
come
up with some ideas what we can offer them. Is there any other
alternatives besides replication and standby database.
Currently the system is running as a package in a cluster environment,
HP-UX, so when we go replication route possibilities are that we might
have to forget about high-availabilty cluster environment due to
things like disk space and memory for switching over during failure.
Neither do the standby database a good option in a situation where
you'll needing a longer downtime.

Please help.

Thanx,

Junior DBA

On Tue, 24 Jun 2003 08:19:18 -0800 
([EMAIL PROTECTED]) wrote:

 
     

Hi there,

I got a question on log. If my program crashes, can I check some log
   
       

to see what
 
     

recent transaction is? It will give me a big help on trouble
   
       

shooting.
 
     

Thanks,
Jin
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author:
 INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051
http://www.fatcity.com
San Diego, California        --
Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] 
(note
EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You 
may
also send the HELP command for other information (like subscribing).
   
       

_______________________________________________________________________
LOOK GOOD, FEEL GOOD -
WWW.HEALTHIEST.CO.ZA

Cool Connection, Cool Price, Internet Access for R59 monthly @ WebMail
http://www.webmail.co.za/dialup/
 
     

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : 
http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ:
http://www.orafaq.net -- Author:
Hemant K Chitale INET:
[EMAIL PROTECTED] Fat
City Network Services -- 858-538-5051
http://www.fatcity.com San Diego,
California -- Mailing list and web hosting services
--------------------------------------------------------------------- To
REMOVE yourself from this mailing list, send an E-Mail message to:
[EMAIL PROTECTED] (note
EXACT spelling of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing list you want to be
removed from). You may also send the HELP command for other information
(like subscribing). 

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : 
http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Jun 27 2003 - 10:47:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US