| 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: Hot Standby
--0-1804289383-965830097=:10269
Content-Type: text/plain; charset=us-ascii
Who says you can't use SQLPLUS? As long as you connect as internal, sysdba, or sysoper, you can.
"Balasubramanian, Sriram" <SBalasubramanian_at_caiso.com> wrote:
Check the difference between these two.
Primary : SELECT MAX(sequence#) FROM v$log_history
Standby : SELECT MAX(sequence#) FROM v$log_history
Since standby is only mounted in standby mode, you cannot connect thru sqlplus. But, you can connect internal using svrmgr to query v$log_history.
sriram
-----Original Message-----
Sent: Monday, August 07, 2000 8:26 PM
To: Multiple recipients of list ORACLE-L
the alert log will tell you which archived redo logs have been applied.....
>From: David Turner
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L
>Subject: Hot Standby
>Date: Mon, 07 Aug 2000 17:05:29 -0800
>
>I would like to write a script that checks how far behind the standby
>database is behind the primary database according to the archive logs
>applied. Anyone know what views to look at? I have looked at
>v$archived_log and some others log, logfile, v$database, and haven't
>found the info I am looking for.
>
>
>Thanks, Dave Turner
>
>--
>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).
-- 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). -- Author: Balasubramanian, Sriram INET: SBalasubramanian_at_caiso.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). --------------------------------- Do You Yahoo!? Kick off your party with Yahoo! Invites. --0-1804289383-965830097=:10269 Content-Type: text/html; charset=us-ascii <P> Who says you can't use SQLPLUS? As long as you connect as internal, sysdba, or sysoper, you can.</P> <P><B><I>"Balasubramanian, Sriram" <SBalasubramanian_at_caiso.com></I></B> wrote: <BR></P> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Check the difference between these two.<BR><BR>Primary : SELECT MAX(sequence#) FROM v$log_history<BR><BR>Standby : SELECT MAX(sequence#) FROM v$log_history<BR><BR>Since standby is only mounted in standby mode, you cannot<BR>connect thru sqlplus. But, you can connect internal using svrmgr<BR>to query v$log_history.<BR><BR>sriram<BR><BR>-----Original Message-----<BR>Sent: Monday, August 07, 2000 8:26 PM<BR>To: Multiple recipients of list ORACLE-L<BR><BR><BR>the alert log will tell you which archived redo logs have been applied.....<BR><BR><BR>>From: David Turner <TURNER_at_TELLME.COM><BR>>Reply-To: ORACLE-L_at_fatcity.com<BR>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_FATCITY.COM><BR>>Subject: Hot Standby<BR>>Date: Mon, 07 Aug 2000 17:05:29 -0800<BR>><BR>>I would like to write a script that checks how far behind the standby<BR>>database is behind the primary database! according to the archive logs<BR>>applied. Anyone know what views to look at? I have looked at<BR>>v$archived_log and some others log, logfile, v$database, and haven't<BR>>found the info I am looking for.<BR>><BR>><BR>>Thanks, Dave Turner<BR>><BR>>--<BR>>Author: David Turner<BR>> INET: turner_at_tellme.com<BR>><BR>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>>San Diego, California -- Public Internet access / Mailing Lists<BR>>--------------------------------------------------------------------<BR>>To REMOVE yourself from this mailing list, send an E-Mail message<BR>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>>the message BODY, include a line containing: UNSUB ORACLE-L<BR>>(or the name of mailing list you want to be removed from). You may<BR>>also send the HELP command for other information (like subscribing).<BR><BR>_________________________________________________________! _______________<BR>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com<BR><BR>-- <BR>Author: Rachel Carmichael<BR>INET: carmichr@hotmail.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR>-- <BR>Author: Balasubramanian, Sriram<BR>INET: SBalasubramanian@caiso.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>-------------------------------------------------------! -------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br> Kick off your party with Yahoo! Invites.Received on Wed Aug 09 2000 - 09:08:17 CDT
 |
 |