Dropping and restoring database schemas

Last Updated : Sep 19, 2020 |

About this task

After installing Avaya Analytics™, you can send test traffic to Avaya Oceana® for validating reports. When you are satisfied with the results, you can delete the test data using the steps in this procedure and start working afresh.

Warning:

These steps delete all data from the Avaya Analytics™ database.

Procedure

  1. Log in to the Cluster Control Manager (CCM) console as the customer user.
  2. Switch to being the root user by entering the command su.
  3. To run the Analytics Administration script, use the following command:

    ccm release orca analytics

  4. Select Database by pressing the corresponding number.
  5. To select the Drop and Restore Database Schemas option, enter the corresponding number.

    The CCM console displays the following warning:

    Continuing will remove all data from Database.

  6. In the Confirm [y/n] field, type y.

    Entering n cancels the operation.

    The CCM console starts installing the schemas and restarts the Avaya Analytics™ database pod.

  7. Return to the previous page by entering b.
  8. Quit the current page by entering q.
  9. Return to the main menu by entering m.