How to full sync the Ranger RMS database

Performing a full-sync in Ranger RMS truncates all the existing data from RMS tables in the Ranger database. The sync process initiates a fresh synchronization from the Hive Metastore (HMS). All available tables and database metadata download from HMS and persist into the Ranger database.

Have a (7.2.18) cluster with Ranger, Ranger RAZ, and Ranger RMS service up and running.

  1. In Cloudera Manager > Ranger_RMS > Actions, click Stop.
  2. In Ranger_RMS > Actions, click Ranger RMS Database Full Sync.
  3. Confirm that the command completed successfully, as shown in the following example:
    Figure 1. Confirming successful Ranger RMS database full sync
    Confirming successful Ranger RMS database full sync
  4. In Cloudera Manager > Ranger_RMS, click Start.