Query reg standby archives
edited Dec 5, 2013 6:29PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 12 commentsAnswered ✓
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
0