-
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|