Skip to Content

remove warm standby pair

Hello,

In order to re build a warm standby with 2 databases, which would be the simplest steps?

(an approach):

-drop connection to <dataserver>.<database>

-drop the maintenance user from the ASE database

-drop the maintenance login from the ASE dataserver

- re enroll the database(s) pair in a the warm stanby


any other steps?


Thanks

Regards

Jose

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Apr 29, 2016 at 08:42 PM

    Mark,

    Ok.Well,sorry about that .

    Actually, I'm trying to rebuild from scratch the WS pair, using ASE 15.7 ( PDS, RDS) and RS 15.7.1.

    It's for only one user database at the PDS and at the RDS. So that is basically.

    Thank you

    Regards

    Jose

    Add a comment
    10|10000 characters needed characters exceeded

    • Off the top of my head ... and assuming the PDB and RDB are not part of some other replication setup (eg, PDB is not serving double duty as a replicate db for another replication setup) ...

      ---------------------------------

      -- in the RS

      drop connection to RDS.RDB

      go

      -- for all repdefs assigned to the logical connection

      -- or active/primary database

      drop replication definition ...

      go

      drop logical connection to LDS.LDB

      go

      -- depending on how the PDS.PDB was created and attached to

      -- the logical connection you may need to run the following;

      -- if you get a message saying the connection doesn't exist

      -- you can ignore said message

      drop connection to PDS.PDB

      go

      ---------------------------------

      -- in the PDS

      use PDB

      go

      sp_stop_rep_agent PDB

      go

      sp_config_rep_agent PDB, disable

      go

      -- sp_config_rep_agent/disable should drop the secondary

      -- trunc pt; if not, or just to be sure:

      dbcc settrunc(ltm,ignore)

      go

      -- at this point if the database is already marked for

      -- replication (eg, sp_reptostandby has already been issued)

      -- then you may want to leave it as is; on the other hand,

      -- if you really want to get back to 'scratch' then:

      sp_reptostandby PDB, 'NONE'

      go

      ---------------------------------

      -- in the RDS

      use RDB

      go

      -- drop the maintuser; depending on its status

      -- as a user or alias to dbo ...

      sp_dropuser maintuser

      -- or

      sp_dropalias maintuser

      go

      ---------------------------------

      -- in the ID Repserver's RSSD

      -- verify physical/logical connections removed from the

      -- rs_idnames table, otherwise you'll have problems adding

      -- the connections back into the system later

      select *

      from rs_idnames

      where (name1 = 'LDS' and name2 = 'LDB')

      or (name1 = 'PDS' and name2 = 'PDB')

      or (name1 = 'RDS' and name2 = 'RDB')

      go

      -- if any of these records exist in the rs_idnames table

      -- then you can either manually delete them (careful that you

      -- only delete the rows in question) or you can drop them by

      -- executing the following in the ID Repserver ...

      ---------------------------------

      -- ID Repserver

      -- to clear entries from rs_idnames, as needed ...

      sysadmin dropdb, PDS, PDB

      sysadmin dropdb, RDS, RDB

      sysadmin dropldb, LDS, LDB

      go


      ---------------------------------


      At this point you should be back to 'scratch' and can proceed through the normal steps for setting up a WS pair.


      NOTE: There's no need to remove the various rs_* objects from the PDB/RDB databases as said objects will be rebuilt by rs_init when adding the PDB and RDB to the system.

  • Posted on Apr 29, 2016 at 08:35 PM

    Your proposed approach is lacking several details re: a WS setup (eg, you don't mention anything about the logical connection, nor do you appear to distinguish between the active/primary and standby/replicate databases) ... so I'd need for a bit more detail of what you're trying to accomplish, eg ...

    What do you mean by 'rebuild'?

    Are you looking to resync the RDB with a dump from the PDB? (If so, what is your RS version?)

    Are you looking to rebuild the WS pair from scratch?

    Are you looking to replace the active/primary or standby/replicate database in a current WS setup? [If so, could you provide some detail on what you have now, and what the new setup will look like?]

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 02, 2016 at 01:11 PM

    Mark,

    Thank you very much. In a way this WS pair is having some issues which one option would be to start from scratch . Currently is somewhat partially down and it's only a one direction replication( no bidirectional) system .

    Regards

    Jose

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.