High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

online redo logs are missed on standby database

Hello Experts,

we have created tow node primary database and created 2 node standby.

standby and primary is in sync.

but problem is, i don't see online redo log file on standby site. i did see entry in control file , but those file doesn't exist on physical location

    GROUP# MEMBER                                                  TYPE
---------- ------------------------------------------------------- -------
        26 /d08/oradata/ORDPRD/onlinelog/redo26_1.log              ONLINE
        26 /d07/oradata/ORDPRD/onlinelog/redo26_2.log              ONLINE
        26 /d08/oradata/ORDPRD/onlinelog/redo26_3.log              ONLINE
        27 /d08/oradata/ORDPRD/onlinelog/redo27_1.log              ONLINE
        27 /d07/oradata/ORDPRD/onlinelog/redo27_2.log              ONLINE
        27 /d08/oradata/ORDPRD/onlinelog/redo27_3.log              ONLINE
        28 /d08/oradata/ORDPRD/onlinelog/redo28_1.log              ONLINE
        28 /d07/oradata/ORDPRD/onlinelog/redo28_2.log              ONLINE
        28 /d08/oradata/ORDPRD/onlinelog/redo28_3.log              ONLINE
        29 /d08/oradata/ORDPRD/onlinelog/redo29_1.log              ONLINE
        29 /d07/oradata/ORDPRD/onlinelog/redo29_2.log              ONLINE
        29 /d08/oradata/ORDPRD/onlinelog/redo29_3.log              ONLINE
        30 /d08/oradata/ORDPRD/onlinelog/redo30_1.log              ONLINE
        30 /d08/oradata/ORDPRD/onlinelog/redo30_2_1.log            ONLINE
        30 /d08/oradata/ORDPRD/onlinelog/redo30_3.log              ONLINE
        31 /d08/oradata/ORDPRD/onlinelog/redo31_1.log              ONLINE
        31 /d07/oradata/ORDPRD/onlinelog/redo31_2.log              ONLINE
        31 /d09/oradata/ORDPRD/onlinelog/redo31_3.log              ONLINE
        20 /d09/oradata/ORDPRD/onlinelog/redo20_1.log              ONLINE
        20 /d07/oradata/ORDPRD/onlinelog/redo20_2.log              ONLINE
        20 /d09/oradata/ORDPRD/onlinelog/redo20_3.log              ONLINE
        21 /d09/oradata/ORDPRD/onlinelog/redo21_1.log              ONLINE
        21 /d07/oradata/ORDPRD/onlinelog/redo21_2.log              ONLINE
        21 /d09/oradata/ORDPRD/onlinelog/redo21_3.log              ONLINE
        22 /d09/oradata/ORDPRD/onlinelog/redo22_1.log              ONLINE
        22 /d07/oradata/ORDPRD/onlinelog/redo22_2.log              ONLINE
        22 /d09/oradata/ORDPRD/onlinelog/redo22_3.log              ONLINE
        23 /d09/oradata/ORDPRD/onlinelog/redo23_1.log              ONLINE
        23 /d07/oradata/ORDPRD/onlinelog/redo23_2.log              ONLINE
        23 /d09/oradata/ORDPRD/onlinelog/redo23_3.log              ONLINE
        24 /d09/oradata/ORDPRD/onlinelog/redo24_1.log              ONLINE
        24

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center