How to Create a SAP Sybase ASE Warm Standby Environment Using rs_init step by step|How to use rs_init utility to create a SAP Sybase ASE Warm Standby Environment

We have request to setup the Sybase ASE warm standby Replication setup

Sybase ASE primary Server Name:-ActiveASE01
Sybase ASE replicated Server Name:-StandbyASE02
Sybase replication server name:-Rep157_01

Sybase ASE version 15.7 and
Sybase replication server 15.7
Using the Pubs2 database

Step-1)Login to ActiveASE01 and enable the Rep_Aganet

sp_configure ‘enable rep agent’,1
go

Step-2)Login to StandbyASE02 and enable the Rep_Aganet

Similary for StandbyASE02
sp_configure ‘enable rep agent’,1
go

Step-3) Now connect the replication server RS157_01 and create the logical connection

create logical connection to LASE.pubs2
go

//Please make note LogicalServerName.DatabaseName(LASE.pubs2)
Step-4) We need to create the physical Active connection using RS_INIT for Active server(ActiveASE01)

Now begain the rs_init utility

cd $SYABSE/REP-15_5/install
./rs_init

It prompts below options

=>RS_INIT
1.Release directory: /opt/sybaserep/157
2.Configure a Server product

Pick option2

=>Configure a Server product
1.Replication Server
Configure Replication Server
1.Install a new replication Server
2.Add a database to replication system
3.Upgrade an existing replication server
4.Downgrade RSSD for an existing replication server
5.Upgrade an existing database in the replication server
6.Enable password encryption for replication server
7.Alter a Replicaiton Serevr Confgireation file password

choose2
1.Replication Server Information
2.Database Information

choose 1-Replication Server Information
replication Server :-RS157_01
Password :- Sybase123

choose 2 Database Information
then we have
1.SQL Sevre name:ActiveASE01
2.SA User :sa
3.SA passord :Sybase123
4.Database name:pubs2
5.will database be replicate Yes
6.Maintenance User:pubs2_maint
7.Maintenance Password:Sybase123
8.Is this a Physical Connection for existing Logical Connection :Yes
9.Logical DB setup

Choose 9
Logiacl Connection Infrmaton
1.IS this an active Connection or standby connection active //Active Connection
2.Locical DS Name:-LASE
3.Logical DB Name:-Pubs2

Replication agent informatio
RS User: REP157_01_ra
RS Password: Sybase123

Executre Replication Server task to activate the Replication

Step-5)Now login to ActiveASE01
use pubs2
go
sp_repstandby ‘pubs2’,all //replicate data schema changes
go
Step-6) Now sync login

bcp master..syslogins out ‘/var/opt/sybase/DUMP/ActiveASE01/syslogins.out’ -Usa -SASE1 -PSybase123 -c -n

Login to StandbyASE02

sp_configure ‘allow updates’,1 //turned on sp_configure system update
go

performed bcp in StandbyASE02

sp_configure ‘allow updates’,0 //turned off sp_configure system update
go
Add minatence user to StandbyASE02
use pubs2
go
sp_adduser pubs2_maint
go
Step-7)Now we are working on standby connection StandbyASE02

Now need to create physical connection using rs_init utility

cd $SYABSE/REP-15_5/install
./rs_init

will get below options
=>RS_INIT
1.Release directory: /opt/sybaserep/157
2.Configure a Server product

pick option2

=>Configure a Server product
1.Replication Server
Configure Replication Server
1.Install a new replication Server
2.Add a database to replication system
3.Upgrade an existing replication server
4.Downgrade RSSD for an existing replication server
5.Upgrade an existing database in the replication server
6.Enable password encryption for replication server
7.Alter a Replicaiton Serevr Confgireation file password

choose2
1.Replication Server Information
2.Database Information
choose 1-Replication Server Information
replication Server :-RS157_01
Password :- Sybase123

choose 2 Database Information
then we have
1.SQL Sevre name :StandbyASE02
2.SA User :sa
3.SA passord:Sybase123
4.Database name:pubs2
5.will database be replicate
6.Maintenance User:pubs2_maint
7.Maintenance Password:Sybase123
8.Is this a Physical Connection for existing Logical Connection :Yes
9.Logical DB setup

Choose 9
Logiacl Connection Infrmaton
1.IS this an active Connection or standby connection active
2.Locical DS Name:-LASE
3.Logical DB Name:-Pubs2
4.Active DS name:-ActiveASE01
5.Active DB Name:-pubs2
6.Active DB sa User: sa
7.Active DB sa Password:Sybase123
8.Initialise sandtby using dump and load :Yes
9.Use Dump marker to start replication to standby :-Yes
Replication agent informatio
RS User ASE156_01_ra
RS Password: Sybase123

Execture the Replication Server task
Step-8) Login active server ActiveASE01

dump database Pubs2 to ‘/var/opt/sybase/dump/ActiveASE01/pubs2.01022017.dmp’
go
Step-9) Login standby server StandbyASE02

Load database Pubs2 from “/var/opt/sybase/dump/StandbyASE02/pubs2.01022017.dmp
go
online database pubs2
go

Step-10) Now add maitenance user to dbo

use pubs2
go
sp_dropuser pubs2_maint
go

sp_addaliase pubs2_maint,dbo
go
Step-11) Login to rep server RS157_01
admin logical_status
go

resume connection to ActiveASE01.pubs2
go
resume connection to StandbyASE02.pubs2
go
admin logical_status
go
admin who_is_down
go
Step-12)
// Now we will test the Active standby ASE enviournment ,Login ActiveASE01:-create the table t1 in pubs2 ,Validate the replication server
create table t1 (int a,int b)
go

insert t1 vaues (1,2)
go

Login to StandbyASE02
use pubs2
go
select * from t1
go

You will find all data replicated in StandbyASE02 from ActiveASE01

 

 

Also you can find

How to Configure MSA type Database Level Sybase ASE Replication Server Step by Step|How to setup Database level Replication in Sybase ASE

Advertisements
Categories SAPSybase

2 thoughts on “How to Create a SAP Sybase ASE Warm Standby Environment Using rs_init step by step|How to use rs_init utility to create a SAP Sybase ASE Warm Standby Environment

  1. Very helpful

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close