redo log sequence number in standby DB

Hi,

I am testing my standby database setup. My standby is running in Manual Recovery Mode because we only have Oracle Standard edition.

After my primary DB generated some archived logs, I transferred them over to the standby. ( both are in Windows 2000 environment) I applied the archived logs (sequence# 90-98) to the standby DB in mounted standby DB mode by doing:

STARTUP NOMOUNT
ALTER DATABASE MOUNT STANDBY DATABASE
SET AUTORECOVERY ON
RECOVER STANDBY DATABASE

This applied all the archived logs I copied over from the primary. However, when I do ARCHIVE LOG LIST as internal on the standby, I get:

SQL> ARCHIVE LOG LIST;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\oracle\oradata\test\archive
Oldest online log sequence 90
Next log sequence to archive 92
Current log sequence 92

Notice the "current log sequence" number is still 92. Is this normal? I thought once I applied the archived log, the log sequence will advance to 98 as well.

Please help!
Thanks,
:confused:

Query V$DATABASE, V$ARCHIVE_DEST_STATUS, V$ARCHIVED_LOG, and V$LOG_HISTORY views in standby machine for details.

Calvin, thanks for the reply.

However, my question is whether ARCHIVE LOG LIST should show the new log sequence number originated from the Primary. In this case, my standby's current log sequence number from ARCHIVE LOG LIST shows 92 but in fact I've applied archived log through 98.

By the way, V$LOG_HISTORY does show log 92 through 98. I wonder where ARCHIVE LOG LIST gets its log sequence number from?

Thanks,

What is the content of V$DATABASE and V$ARCHIVE_DEST_STATUS?