SAP Sybase ASE Warm Standby Database using Replication Server

 

We are going to create warm standby backup of SAP Sybase ASE Prod1 server to Standby1 server using Sybase Replication Server REP15_7 for a database named : testdb. It comprises to the following 15 steps.

Pre-Requisites :

a) 2 Sybase ASE instances

b)1 replication server instance

c)1 database named testdb

 

Step 1: Enable Replication Agent on both Sybase ASE Servers

 

Step 2: Create a login that on both Sybase ASE Servers and assign replication_role

These logins will be used in Replication Process

Create logins  on both server

 

Step 3: Add the user to the dbo profile of the database that is invlovled in this process.

 

Step 4: Synchronize the logins on both the servers if required

execute this to export logins for primary server:

 

Step 5: Install the replication script for both Primary & Standby Servers

Login to rep server and browse the script from location $SYBASE/REP15-5_5/scripts and execute this:

 

Step 6: Create logical connection on replication server

Connect to the replication server and execute this

 

Step 7: Create a connection from replication serer to active database

 

Step 8: Create a login in the replication server

This user will be used to connection replication agent from Sybase ASE Servers

 

Step 9: Create a connection from the replication server to the standby server

 

Step 10: Check the logical connections

execute the following command on replication server

 

Step 11: Mark the database for replication and grant permissions

Execute the following command on primary server to grant permissions and activate the database to capture all activities for production database by executing the commands:

 

Step 12: Configure Replication Agent on primary server

Execute the following command on primary server to configure replication agent on primary server

 

Check the error log to verify the status of replication agent.

Step 13: Dump the database on primary server

 

Step 14: Restore the database on standby server

 

Step 15: Resume the connection on Primary & Standby Servers and verify the replication status

Connect the replication server and execute the following commands to resume the connections of primary & secondary servers to replication server respectively.

 

Step 16: Validate the replication between primary & standby servers

Primary:

DONE!!!

This Post Has 4 Comments

  1. Pranaw

    Great article, replication explained in easy steps.

    1. Engr. Mohammad Rizwan Yasin

      Thanks!

  2. Marc Daccache

    Dear Engr. Mohammad Rizwan Yasin,
    Good article. A major step needs to be added. You will have to disable rep agent on standby and to disable the secondary truncation point in to avoid the transaction log on DR to fill up.

    This can be done via connecting to Standby and run:

    use db_name
    go
    sp_config_rep_agent db_name, ‘enable’
    go
    dbcc settrunc (‘ltm’,ignore)
    go

    1. Marc Daccache

      Sorry!
      Typo error:

      sp_config_rep_agent db_name, ‘disable’
      go

Leave a Reply