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

Home -> Community -> Mailing Lists -> Oracle-L -> archive log list of standby database does not display SCN# of rec

archive log list of standby database does not display SCN# of rec

From: Paul Drake <drake_at_psscorp.com>
Date: Thu, 2 Nov 2000 17:33:37 -0500
Message-Id: <10668.121013@fatcity.com>


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? Received on Thu Nov 02 2000 - 16:33:37 CST

Original text of this message

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