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

MOSC Banner

Query reg standby archives


Hi Team,

Need your help in understanding why still we are seeing few Nov 1'st archives as not applied in DR site:

STANDBY Recovery GAP Last ARCH Applied
-------------------- ------------------------------------
                   1 Tue 03-Dec-2013 02:33:34


    Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
         1                 163078                163076          2
         2                 132244                132244          0


 SEQUENCE# APP
---------- ---
    130367 NO
    130367 NO
    130457 NO
    130458 NO
    132244 NO
    160791 NO
    163076 NO
    163077 NO
    163078 NO

9 rows selected.

[orauat@oraplayersdr01 DRUAT]$ ls -ltr *130367* *130457* *130458* *132244*  *160791* *163076* *163077* *163078*
-rw-r----- 1 orauat oinstall 111136127 Nov  1 06:01 arch_2_130457_614314731.arc                       ----------- All these 4 archives
-rw-r----- 1 orauat oinstall 109492192 Nov  1 06:09 arch_2_130458_614314731.arc                      ----------- belongs
-rwxrwxrwx 1 orauat oinstall  72219615 Nov  1 23:28 arch_2_130367_614314731.arc                 ----------- to
-rwxrwxrwx 1 orauat oinstall  63729320 Nov  1 23:33 arch_1_160791_614314731.arc                 ----------- Nov 1st
-rw-r----- 1 orauat oinstall 517337088 Dec  3 02:58 arch_1_163076_614314731.arc

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