LogSync seems to be does not work on Real Time Apply Standby

  • 0
  • 1
  • Problem
  • Updated 3 years ago
  • Acknowledged
Good day.

We are using delphix_demo with Standby in RealTime Apply.
All archivelogs are in place for 48 hours.
Why LogSync cannot grab them?

See screenshot.



Maybe this is due to the time zone?
https://community.delphix.com/delphix/topics/outdated-moscow-time-zone

--
Product
Delphix Engine - Demo

Version
Delphix Engine - Demo 4.1.6.0

Build Date
Tue, 3 Mar 2015 08:33:12 GMT
Photo of Su

Su

  • 280 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Hello,

From screen shot you provided I assume that you have a problem with SnapSync.
If dSource is connected to Standby database please check Delphix documentation what configuration is supported.


https://docs.delphix.com/display/DOCS42/Linking+Oracle+Physical+Standby+Databases

By default SCN backup is used so you need to stop log apply and open database in read only mode.
Please check example script in documentation.

If you have any other questions please don't hesitate to ask.

regards,
Marcin
Photo of Su

Su

  • 280 Points 250 badge 2x thumb
Hello, Marcin.

"Both Oracle bug 10146187 and 13075226 are fixed starting from Oracle 11.2.0.4. There is no need to configure stop and restart of Redo Apply or disable BCT if the Physical Standby Database is at version 11.2.0.4 or above."

BANNER
------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
(Edited)
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Is LogSync enabled for this dSource? Does LogSync say ACTIVE on your dSource card? I see the snapshot cards, but that is a result of SnapSync, not LogSync. Flip the card over on the dSource, and set Logsync to Enabled.
Photo of Su

Su

  • 280 Points 250 badge 2x thumb
Hello, Adam.


Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Do any of the faults pertain information about failed LogSyncs?
Photo of Su

Su

  • 280 Points 250 badge 2x thumb
btw,

"May 28, 2015 1:25 PM" - wrong time. (Moscow TZ = 03, not 04)

Must be "May 28, 2015 12:25 PM"



Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Thank you. This bit is helpful. I am getting some other eyes on this. We will get back to you soon,
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
How big is the archivelog size? How quickly are the logs switching?
Photo of Su

Su

  • 280 Points 250 badge 2x thumb
SQL> select completion_time, round(blocks*512/1024/1024) Mb, name from v$archived_log
  2  where standby_dest='YES' and
  3  completion_time > sysdate- 10/24
  4  order by 1 desc;

COMPLETION_TIME              MB NAME
-------------------- ---------- -------------------------------------------------------
28-MAY-2015 14:31:07       1503 CFTBANK_CFT-STB
28-MAY-2015 14:21:21       1509 CFTBANK_CFT-STB
28-MAY-2015 14:05:11       1511 CFTBANK_CFT-STB
28-MAY-2015 13:59:38       1536 CFTBANK_CFT-STB
28-MAY-2015 13:41:04       1513 CFTBANK_CFT-STB
28-MAY-2015 13:29:03       1503 CFTBANK_CFT-STB
28-MAY-2015 13:13:49       1503 CFTBANK_CFT-STB
28-MAY-2015 13:02:00       1501 CFTBANK_CFT-STB
28-MAY-2015 12:50:24       1506 CFTBANK_CFT-STB
28-MAY-2015 12:44:11       1507 CFTBANK_CFT-STB
28-MAY-2015 12:31:49       1526 CFTBANK_CFT-STB
28-MAY-2015 12:25:01       1504 CFTBANK_CFT-STB
28-MAY-2015 12:14:42       1504 CFTBANK_CFT-STB
28-MAY-2015 12:04:02       1501 CFTBANK_CFT-STB
28-MAY-2015 11:53:02       1507 CFTBANK_CFT-STB
28-MAY-2015 11:41:37       1556 CFTBANK_CFT-STB
28-MAY-2015 11:39:55       1552 CFTBANK_CFT-STB
28-MAY-2015 11:38:10       1604 CFTBANK_CFT-STB
28-MAY-2015 11:36:23       1537 CFTBANK_CFT-STB
28-MAY-2015 11:34:37       1575 CFTBANK_CFT-STB
28-MAY-2015 11:31:04       1504 CFTBANK_CFT-STB
28-MAY-2015 11:21:48       1502 CFTBANK_CFT-STB
28-MAY-2015 11:18:27       1552 CFTBANK_CFT-STB
28-MAY-2015 11:16:48       1586 CFTBANK_CFT-STB
28-MAY-2015 11:15:12       1568 CFTBANK_CFT-STB
28-MAY-2015 11:13:36       1578 CFTBANK_CFT-STB
28-MAY-2015 11:12:00       1570 CFTBANK_CFT-STB
28-MAY-2015 11:10:27       1600 CFTBANK_CFT-STB
28-MAY-2015 11:03:53       1508 CFTBANK_CFT-STB
28-MAY-2015 10:52:41       1512 CFTBANK_CFT-STB
28-MAY-2015 10:42:43       1508 CFTBANK_CFT-STB
28-MAY-2015 10:36:04       1574 CFTBANK_CFT-STB
28-MAY-2015 10:34:28       1552 CFTBANK_CFT-STB
28-MAY-2015 10:32:43       1540 CFTBANK_CFT-STB
28-MAY-2015 10:31:07       1550 CFTBANK_CFT-STB
28-MAY-2015 10:29:31       1558 CFTBANK_CFT-STB
28-MAY-2015 10:28:01       1578 CFTBANK_CFT-STB
28-MAY-2015 10:26:19       1556 CFTBANK_CFT-STB
28-MAY-2015 10:24:40       1552 CFTBANK_CFT-STB
28-MAY-2015 10:23:04       1563 CFTBANK_CFT-STB
28-MAY-2015 10:21:30       1545 CFTBANK_CFT-STB
28-MAY-2015 10:13:21       1515 CFTBANK_CFT-STB
28-MAY-2015 10:04:32       1513 CFTBANK_CFT-STB
28-MAY-2015 09:52:58       1505 CFTBANK_CFT-STB
28-MAY-2015 09:36:30       1502 CFTBANK_CFT-STB
28-MAY-2015 09:19:10       1503 CFTBANK_CFT-STB
28-MAY-2015 08:59:32       1065 CFTBANK_CFT-STB
28-MAY-2015 08:39:34        889 CFTBANK_CFT-STB
28-MAY-2015 08:19:32        882 CFTBANK_CFT-STB
28-MAY-2015 07:59:33        665 CFTBANK_CFT-STB
28-MAY-2015 07:39:32        390 CFTBANK_CFT-STB
28-MAY-2015 07:19:33        349 CFTBANK_CFT-STB
28-MAY-2015 06:59:34        328 CFTBANK_CFT-STB
28-MAY-2015 06:39:28        301 CFTBANK_CFT-STB
28-MAY-2015 06:19:26        283 CFTBANK_CFT-STB
28-MAY-2015 05:59:26        259 CFTBANK_CFT-STB
28-MAY-2015 05:39:27        193 CFTBANK_CFT-STB
28-MAY-2015 05:19:27        187 CFTBANK_CFT-STB
28-MAY-2015 04:59:27        149 CFTBANK_CFT-STB

59 rows selected.
Photo of Tim Gorman

Tim Gorman, Field Services

  • 2,794 Points 2k badge 2x thumb
Su,

I'm not fully clear on why the archived redo log files were not captured by either the LogSync or SnapSync services, but I'm investigating on a customer account.

Regardless, it is a something to be resolved.  Please note from your very first screenshot in this forum thread showing the database card and fault?  Please note that there are two little icons on the card to the right of the words "Missing Archive Logs"?  One looks like the lower-case letter "i" in a blue circle (a.k.a. more information), the other looks (to me at least) like a screw-driver with wings (your eyesight may be better and interpretation may be different :-) )?

Those icons relate to the "Log Repair Tool", specifically the little flying screwdriver thingie.  You can click on that and see if it is of some use, following the documentation found online here and in the child page here.

Personally, I'm a command-line sort of person, so I prefer to use the Delphix CLI version of the "Log Repair Tool".  To access that, connect via SSH into the "delphix_admin" account (or any administrator account) into the Delphix Engine VM, then execute the following command...

    /timeflow oracle log list database=<db-name> missing=true

...where the "<db-name>" is the name of the dSource in question (i.e. "cftbank_from_Standby").

There is more information on using both "Log Repair Tools" in the online documentation both here and here.

Hope this helps...

Thanks!