Mount the standby database and bring it online

If you use the snapshot materialization mount database option for a standby database in Adaptive Server version 12.5.1 or later, you must:

NoteSkip this procedure if you use snapshot materialization for a standby database in Adaptive Server version 12.5.0.3. See “Start the standby database” for more information.

See Appendix A, “Materializing Databases,” for more information about materialization options for the standby database.

NoteYou must have a System Administrator or Database Owner user role in the standby Adaptive Server to perform this procedure.

StepsTo mount the standby database and bring it online

  1. Log in to the standby Adaptive Server with a System Administrator or Database Owner user role.

  2. Mount the database on the standby data server:

    mount database all from pdb_manifest
    

    where pdb_manifest is the manifest file created by the quiesce command at the primary database.

    When you invoke mount, Adaptive Server performs all of the required supporting activities, including adding database devices and activating them, creating the catalog entries for the new database, and recovering the database.

  3. After the database is recovered on the standby data server, bring the database online:

    online database sdb
    

    where sdb is name of the standby database.

The names of the standby database and primary database must be the same.