redo log sequence number in standby DB
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:
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.
Click Here to Expand Forum to Full Width