| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9i standby
there are actually two kinds of "standby" that they are talking about in 9i..
if you use the logminer to generate the SQL for the standby db, then you are applying SQL statements to the standby and you can run read-only transactions about it.
If you go to oracle online ed, there is a presentation on high availability there that you can sign up for (free registration) and it talks about this.
Rachel
>From: "JOE TESTA" <JTESTA_at_longaberger.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: 9i standby
>Date: Thu, 12 Jul 2001 12:05:57 -0800
>
>Page 61 of Oracle 9i, Data Guard concept.pdf
>
>says the standby can be in one of 2 states, open for read-only or in
>managed recovery mode. if its open in read only, it can't have logs
>applied. I've not gotten around to testing that 9i concept yet. although
>it looks like it will be kewl to flip between primary and standby WITHOUT
>rebuilding :)
>
>hth, joe
>
>
>
> >>> turner_at_tellme.com 07/12/01 03:26PM >>>
>
>Anyone know if the standby in 9i can be in readonly mode while the logs are
>being applied? I've heard about this as being the case and also that this
>isn't
>the case.
>
>Thanks, Dave Turner
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: David Turner
> INET: turner_at_tellme.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 Thu Jul 12 2001 - 17:07:15 CDT
 |
 |