Following steps we can use for syncing the replicated database from the primary database in warm standby setup.
PDS - Primary Dataserver
PDB - Primary Database
RDS - Replicated Dataserver
RDB - Replicated Database in RDS
Step #1
Put database PDB in dbo use only
Clean up all logins besides systems, ( terminate all user processes )
Step #2
Quiese the replication server.
isql -Usa -Ppasswd -SRS
1> admin quiesce_check
2> go
Replication Server RS is Quiesced
1>
Step #3
Stop the rep agent thread of Primary Database.
isql -Usa -Ppasswd -SPDS
use PDB
go
sp_stop_rep_agent PDB
go
Step #4
Suspend the connection to Primary database. Login into the Replication Server and issue the following command.
isql -Usa -Ppasswd -SRS
suspend connection to PDS.PDB
go
Step #5
Ignore the secondary transaction point in Primary Database.
isql -Usa -Ppasswd -SPDS
use PDB
go
dbcc settrunc('ltm', 'ignore')
go
Step #6
Truncate the tran log and reset the locator value to zero. Please only execute if the above step was successful.
isql -Usa -Ppasswd -SPDS
dump tran PDB with truncate_only
go
Issue this command in RSSD database.
rs_zeroltm PDS, PDB
go
Step #7
Dump the primary database.
isql -Usa -Ppasswd -SPDS
dump database PDB to '/dumpfs/PDB.dmp'
go
Step #8
Transfer the dump to RDS and load the RDB.
isql -Usa -Ppasswd -SRDS
load database RDB from '/sybase/RDS/dumpfs/PDB.dmp'
go
Step #9
Valid the secondary tran point in PDS.
isql -Usa -Ppasswd -SPDS
use PDB
go
dbcc settrunc('ltm', 'valid')
go
Step #10
Start the repagent for PDB in PDS.
isql -Usa -Ppasswd -SPDS
use PDB
go
sp_start_rep_agent PDB
go
Step #11
Resume the connection from the PDS.PDB in Replication Server.
isql -Usa -Ppasswd -SRS
resume connection to PDS.PDB
go
Step #12
Remove DBO use only from db.
