Can we run LogSync against Oracle/MSSQL dSource separate from SnapSync in 5.2.3?

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
In fact is this passible to run only LogSync on dSource every 30min? Because customer's backup policy archives ARCH files frequently (every 1 hour).
Photo of Marcin

Marcin

  • 616 Points 500 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Ranzo Taylor

Ranzo Taylor, Employee

  • 1,604 Points 1k badge 2x thumb
LogSync is not a scheduled batch job, it runs continuously and will pick up archive logs within minutes of their creation.  You can run SnapSync once a day (for example), but you'll still have point-in-time recovery options because of LogSync.

You can also disable LogSync.  SnapSync will always gets the logs it needs to make a snapshot recoverable (and therefore able to make VDBs!)

You could disable LogSync and run SnapSync every hour if you like, and that would give you 24 recovery points a day and saves space on your Delphix engine.  

Finally, you can have separate retention for logs, for example 90 days of snapshots and 2 days of logs would give you point-in-time recovery for a couple of days, and less granular options for a long duration.
(Edited)
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,862 Points 4k badge 2x thumb

Hi Marcin,

Just to complete Ranzo's update and give you some tracks to explore.

https://www.delphix.com/blog/data-virtualization/understanding-snapsync-and-logsync-oracle

To achieve your need explore one of those options if possible :

1) Ask customer to change the purge/backup policy of archivelogs (hard to negotiate because of customers reasons SLA, HDD space ...)
2) Configure delphix to take frequent snapshots lets say every 50min if the customer policy is 1 hour, but you will end up with a lot of snapshot cards 29 per day
3) Just ask customer to introduce a call to delphix api to take snapshot before archiving ARCH files
2 and 3 are similar only the way changes 
4) Delphix livesource (aka. virtual dataguard), you will not have to worry about arch as you will be synced with redo
 

Regards,

Mouhssine