Home > Default > Determining Gaps in Logical Standby

Determining Gaps in Logical Standby

November 30Hits:0
Advertisement
DB version: 11.2
For determining the gaps for Physical Standby DB, I use the queries mentioned in the post below
StandbyDB is not in sync with primary
For checking if a Logical Standby and Primary is in Sync, Can I use the same query ? Do I have to consider any other factors for Logical standby when checking for gaps ?

Answers

Hello;
Which part of that huge post! I'm thinking No, because that is not a Logical Standby.
On a logical standby database, query the DBA_LOGSTDBY_LOG view on the logical standby database :
COLUMN FILE_NAME FORMAT a55
SELECT
  THREAD#, SEQUENCE#, FILE_NAME
FROM
  DBA_LOGSTDBY_LOG L
WHERE
  NEXT_CHANGE# NOT IN
    (SELECT FIRST_CHANGE# FROM DBA_LOGSTDBY_LOG WHERE L.THREAD# = THREAD#)  ORDER BY THREAD#, SEQUENCE#;The Data Guard Concepts and Administration Oracle document should have a "Redo Transport Services" section on this.
Another one, also run on the logical standby :
SELECT
  SUBSTR(FILE_NAME,1,100) FILE_NAME, SUBSTR(SEQUENCE#,1,10) "SEQ#",
  FIRST_CHANGE#, NEXT_CHANGE#, TO_CHAR(TIMESTAMP, 'HH:MI:SS') TIMESTAMP,
  DICT_BEGIN BEG, DICT_END END, SUBSTR(THREAD#,1,4) "THR#"
FROM
  DBA_LOGSTDBY_LOG
ORDER BY
  SEQUENCE#;
  Best Regards
mseberg

Read other 3 answers

Tags:

Related Articles

  • Determining Gaps in Logical StandbyNovember 30

    DB version: 11.2 For determining the gaps for Physical Standby DB, I use the queries mentioned in the post below StandbyDB is not in sync with primary For checking if a Logical Standby and Primary is in Sync, Can I use the same query ? Do I have to c

  • Logical standby | archive log deleted | how to remove gap ???October 11

    hi gurus... i have problem on logical standby by mistake standby log coming to logical standby has been deleted , now how to fill up the gap ??? ON STANDBY SEQUENCE# FIRST_CHANGE# NEXT_CHANGE# APPLIED 228 674847 674872 YES 229 674872 674973 CURRENT 2

  • Determining the last archive applied on Logical StandbyNovember 30

    Hi, I am trying to determine the last log received and applied on my Logical Standby SQL> select thread#, max(sequence#) "Last Standby Seq Received" from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# g

  • Best practice on using Flashback and Logical StandbyOctober 11

    Hello, I'm testing a fail-back scenario where I first need to activate a logical standby, then do some dummy transactions before I flashback this db and resme the redo apply. Here is what the steps look like: 1)     Ensure logical standby is in-sync

  • Logical standby stuck at initializing SQL apply only coordinator process upOctober 11

    Hi OS: solaris 5.10 Hardware: sun sparc Oracle database: 11.2.0.1.0 Primary database name: asadmin Standby database name: test I had been trying to convert a physical standby to logical standby database. Both the primary and standby reside on the sam

  • Logical Standby Database Not Getting Sync With Primary DatabaseOctober 11

    Hi All, I am using a Primary DB and Logical Standby DB configuration in Oracle 10g:- Version Name:- SQL> select * from v$version; BANNER Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production CORE 10.2

  • MV Logs not getting purged in a Logical Standby DatabaseOctober 11

    We are trying to replicate a few tables in a logical standby database to another database. Both the source ( The Logical Standby) and the target database are in Oracle 11g R1. The materialized views are refreshed using FAST REFRESH. The Materialized

  • Log mining is taking too much time in logical standby databaseOctober 11

    dear DBAs, today i found a gap between the production database and the logical standby database and i found that the log mining is taking more than 1 hour to complete an archivelog (size: 500M) note that the MAX_SGA is 1500M and the MAX_SERVERS=45 th

  • How to apply the changes in logical standby databaseOctober 11

    Hi, I am new to Dataguard. I am now using 10.2.0.3 and followed the steps from Oracle Data Guard Concepts and Administration Guide to setup a logical standby database. When I insert a record to a table from the primary database side, when i query the

  • Refresh Schema in Primary (and Logical Standby)October 11

    Does anyone have a recommendation for the best way to refresh a 16Gb schema in a Primary Database that has a logical standby? I attempted to refresh our main schema in our Primary by using IMPDP. I tried to follow the same steps as I would if I had t

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 1.029 s.