redo log sequence number in standby DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: redo log sequence number in standby DB

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    Question 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,

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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

  3. #3
    Join Date
    Apr 2001
    Posts
    257
    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-19-2002 at 11:43 PM.

  4. #4
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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
  •  



Click Here to Expand Forum to Full Width