Creating an RPS Database from a Quiesced or Offline Backup of the Primary

You can create an RPS node from an online quiesced or an offline backup of the primary, by using the following steps as an alternative to the Create RPS Database command initiated from the primary RPS Manager (documented under "Creating the RPS Database", elsewhere in this chapter).

  1. Restore a recent online quiesced or offline backup to the RPS database location.

  2. Start up the RPS database server.

    If you want to convert a primary database backup to an RPS node outside of the RPS Manager, set the required values of the Schema, Mapping, and DatabaseType parameters in the [JadeRpsManager] section of the Jade initialization file.

  3. Start up the RPS Manager application. The Select RPS Mapping dialog is then displayed.

  4. Select the schema from the tree view and the RPS mapping from the list box.

  5. The Configure RPS Node dialog is then displayed, which displays the settings of parameters configured in the Jade initialization file.

    Check and alter parameters, if required (for example, directory locations and options), and then click the OK button on the dialog.

  6. Set up the RDBMS from the RPS Manager, as required.

From Jade 2025, steps 3 through 5 in the previous instruction can be skipped if you already have a valid RPS configuration in the [JadeRpsManager] section of the Jade initialization file. Jade will now read and write the following parameter settings to allow this.

[JadeRpsManager]
Schema=schema_name
Mapping=mapping_name
DatabaseType=SQL_datatype_override

The values of the Schema and Mapping parameters are case-sensitive, and should be a valid schema and RPS mapping name.

If the value of the AutoStartDataPump parameter in the [JadeRps] section of the Jade initialization file is set to true when the RPS node is started and both the Schema and Mapping parameters are specified and valid, the RPS Datapump is started automatically. If either the specified schema or RPS mapping is invalid, a message is logged and the RPS monitor will not start.

If you want to override the value stored on the RPS Mapping, you can specify the DatabaseType parameter, which can be specified as one of:

If one of these values is not specified, the DatabaseType parameter is specified as <default>, which means that the default value of the database backup RPS mapping for the specified relational database type is used.