-
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,
-
Query V$DATABASE, V$ARCHIVE_DEST_STATUS, V$ARCHIVED_LOG, and V$LOG_HISTORY views in standby machine for details.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
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,
Last edited by a128; 11-20-2002 at 12:43 AM.
-
What is the content of V$DATABASE and V$ARCHIVE_DEST_STATUS?
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
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
|