Quiesce the primary database

You must quiesce the primary database to suspend update activities until the standby database is materialized and the Mirror Replication Agent is initialized.

NoteFor ASE: You must have a system administrator user role in the primary Adaptive Server to perform this procedure.

Any activity that would change the schema in the primary database should not be allowed to take place while Mirror Replication Agent is initializing. Select a time when there are no users on the system or quiesce the primary database.

StepsQuiescing an ASE primary database

  1. Log in to the primary database server with a system administrator user role.

  2. Quiesce the primary database.

    • If you use snapshot materialization for a standby database in ASE, use the following command to quiesce the primary database:

      quiesce database MA_setup hold pdb
      

      where:

      • MA_setup is a user-defined tag that identifies the database.

      • pdb is the name of the primary database.

    • If you use the snapshot materialization mount database option for a standby database in ASE use the following command to quiesce the primary database:

      quiesce database MA_setup hold pdb 
      for external dump to pdb_manifest
      

      where:

      • MA_setup is a user-defined tag that identifies the database.

      • pdb is the name of the primary database.

      • pdb_manifest is the name of the manifest file.

StepsQuiescing an Oracle primary database

  1. Log in to the primary database, and issue the following command:

    ALTER SYSTEM QUIESCE RESTRICTED