Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: archive log list of standby database does not display SCN# of rec
I think you are looking at it incorrectly -- the archive log list
information refers to the next redo log to archive -- which doesn't happen
while you are in standby and doing recovery.
Rachel
>From: Paul Drake <drake_at_psscorp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: archive log list of standby database does not display SCN# of rec
>Date: Thu, 02 Nov 2000 14:51:10 -0800
>
>Oracle 8.1.6.1.3 Standard Edition
>WinNT Server 4.0 SP6a
>Standby Database
>
>I recently installed a standby database for a Client.
>This evening I was examining the day's logfile processing, where I found
>this:
>
>"archive log list" in Server Manager connected to standby database does not
>display SCN# of current recovery.
>
>C:\>svrmgrl
>
>Oracle Server Manager Release 3.1.6.0.0 - Production
>
>Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
>Oracle8i Release 8.1.6.1.0 - Production
>JServer Release 8.1.6.0.0 - Production
>
>SVRMGR> connect internal/<mypass>
>Connected.
>SVRMGR> STARTUP NOMOUNT
>PFILE=D:\Oracle\admin\<dbname>\pfile\initstandby.ora
> 2> /
>Statement processed.
>SVRMGR> ALTER DATABASE MOUNT STANDBY DATABASE
> 2> /
>Statement processed.
>SVRMGR> archive log list
>Database log mode Archive Mode
>Automatic archival Enabled
>Archive destination F:\Oracle\oradata\<dbname>\archive
>Oldest online log sequence 798
>Next log sequence to archive 800
>Current log sequence 800
>SVRMGR> select max(sequence#) from v$loghist;
>MAX(SEQUEN
>----------
> 825
>1 row selected.
>SVRMGR> quit
>
>Is this just a misunderstanding on my part, or does this seem like an
>issue?
>
>thanks,
>
>Paul
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Drake
> INET: drake_at_psscorp.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).
Share information about yourself, create your own public profile at Received on Thu Nov 02 2000 - 20:11:58 CST
![]() |
![]() |