{"id":4201,"date":"2021-07-29T10:36:46","date_gmt":"2021-07-29T10:36:46","guid":{"rendered":"https:\/\/www.esds.co.in\/kb\/?p=4201"},"modified":"2021-08-02T11:42:57","modified_gmt":"2021-08-02T11:42:57","slug":"disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications","status":"publish","type":"post","link":"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/","title":{"rendered":"Disaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite Applications"},"content":{"rendered":"\n

During the initial load and replication, the replication agent (RMA) reads the transaction log of the source database and generates the Log Transfer Language (LTL) output, which is a notation (using a language) that the replication server (SRS) uses to process identified and collected data throughout the replication channel from the source to the target database.<\/p>\n\n\n\n

The primary replication server (SRS) receives the LTL from a replication agent and sends the replicated data to the companion replication server (Standby\/DR Site) (when a split between primary replication server and replicate replication server is used). Otherwise, the sending does not take place because the data is operated by the single replication server instance). The companion replication server converts the received data from the LTL to the native format and language used by the target database. It sends the replicate data to the target database for processing, which closes the replication process (if it is committed in the target database).<\/p>\n\n\n\n

For data consistency reasons (no loss of data) each replication server uses a database called the Replication Server System Database (RSSD) to store replication data and metadata. This information can be used by a replication agent to provide advanced replication features such as the transfer of database data logic (procedures).<\/p>\n\n\n\n

There is a replication of DC & DR<\/a><\/strong>. For replication, the basic requirement is that both the databases need to be on the same DR side. In this particular case, the replication was stopped at the DR side & we did the migration of the entire DC Site\u2019s database (taken from the client) along with the Transaction log to get the same in the same sync. Once it is done, the DC and DR get successfully synced under the replication configuration process.<\/p>\n\n\n\n

In case you also face a similar issue, go through the following steps and overcome your concerns with utmost ease.<\/p>\n\n\n\n

Sybase database load <\/strong><\/p>\n\n\n\n

Log in to windows server<\/strong> > USER<\/strong> > PRXXXX<\/strong><\/p>\n\n\n\n

\"Disaster<\/figure><\/div>\n\n\n\n

C:\\Users\\prXXXX\\Downloads\\PRX2X0121.dmp<\/strong><\/p>\n\n\n\n

Go to power shell<\/strong><\/p>\n\n\n\n

Login database Command >> isql -Usapsa -SPRD -X -XXXXXXXXX -w9999<\/strong><\/p>\n\n\n\n

Database available path<\/strong><\/p>\n\n\n\n

Database load >> load database PRD from ‘C:\\Users\\prXXXX\\Downloads\\PRX1X0721.dmp’<\/strong><\/p>\n\n\n\n

\"Disaster<\/figure><\/div>\n\n\n\n

Full DATA base completed<\/strong><\/p>\n\n\n\n

\"Disaster<\/figure><\/div>\n\n\n\n

We have checked the transaction log<\/strong><\/p>\n\n\n\n

\"Disaster<\/figure><\/div>\n\n\n\n

Go to a database in Sybase DB and fire the recovery transaction log<\/strong><\/p>\n\n\n\n

load transaction PRD from <\/strong><\/p>\n\n\n\n

‘D:\\sybase\\SybLogs\\PRD-20XXX-07-16T12-00-01.dbxxn’<\/strong><\/p>\n\n\n\n

and checked the transaction load completed.<\/strong><\/p>\n\n\n\n

\"Disaster<\/figure><\/div>\n\n\n\n

After checked the log for the path >> D:\\sybase\\PRD\\ASE-16_0\\install<\/strong><\/p>\n\n\n\n

\"Disaster<\/figure><\/div>\n\n\n\n

Check log status<\/strong><\/p>\n\n\n\n

\"Disaster<\/figure><\/div>\n\n\n\n

Replication is in sync mode from the DC server<\/strong><\/p>\n\n\n\n

\"Disaster<\/figure><\/div>\n\n\n\n

Here you go! You have successfully done with Performing Sybase Concurrent Transaction Log Backup with Full Database Backup<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

During the initial load and replication, the replication agent (RMA) reads the transaction log of the source database and generates the Log Transfer Language (LTL) output, which is a notation (using a language) that the replication server (SRS) uses to process identified and collected data throughout the replication channel from the source to the target… <\/p>\n

<\/div>\n

Read More<\/a><\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1047],"tags":[1069,663,501,1067,1070,1068],"aioseo_notices":[],"yoast_head":"\nDisaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite Applications<\/title>\n<meta name=\"description\" content=\"Guided steps to Setup Disaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite applications.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Disaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite Applications\" \/>\n<meta property=\"og:description\" content=\"Guided steps to Setup Disaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite applications.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/\" \/>\n<meta property=\"og:site_name\" content=\"ESDS Official Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ESDSdc\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-29T10:36:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-02T11:42:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esds.co.in\/kb\/wp-content\/uploads\/2021\/08\/1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ESDSDataCenter\" \/>\n<meta name=\"twitter:site\" content=\"@ESDSDataCenter\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"4 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#website\",\"url\":\"https:\/\/www.esds.co.in\/kb\/\",\"name\":\"ESDS Official Knowledgebase\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.esds.co.in\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.esds.co.in\/kb\/wp-content\/uploads\/2021\/08\/1.png\",\"width\":967,\"height\":381},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/#webpage\",\"url\":\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/\",\"name\":\"Disaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite Applications\",\"isPartOf\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/#primaryimage\"},\"datePublished\":\"2021-07-29T10:36:46+00:00\",\"dateModified\":\"2021-08-02T11:42:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/#\/schema\/person\/014a2b8fc18f418e4a3f7b89500e361d\"},\"description\":\"Guided steps to Setup Disaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite applications.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/\",\"url\":\"https:\/\/www.esds.co.in\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/\",\"url\":\"https:\/\/www.esds.co.in\/kb\/disaster-recovery-dr-site-for-sap-ase-sybase-database-running-with-sap-business-suite-applications\/\",\"name\":\"Disaster Recovery (DR) Site for SAP ASE (Sybase) Database running with SAP Business Suite Applications\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#\/schema\/person\/014a2b8fc18f418e4a3f7b89500e361d\",\"name\":\"Dinesh Yadav\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4a318d6752a794e525d7f801ea785767?s=96&d=mm&r=g\",\"caption\":\"Dinesh Yadav\"},\"description\":\"Dinesh Yadav received the BA from BHOJ Institute of Bhopal, in 2019. He is passionate about research SAP HANA replication, HANA cluster managed, HANA migration activity & Sybase replication managed, and SAP installation per client requirement. about the latest technologies. He currently works as an SAP- Basis at ESDS software solution. He has been working with challenged clients for over eleven years.\",\"sameAs\":[\"https:\/\/www.esds.co.in\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/4201"}],"collection":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/comments?post=4201"}],"version-history":[{"count":7,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/4201\/revisions"}],"predecessor-version":[{"id":4227,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/4201\/revisions\/4227"}],"wp:attachment":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/media?parent=4201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/categories?post=4201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/tags?post=4201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}