cleanup_dbaas_requests

Cleans up requests from the host and Enterprise Manager. Depending on the options specified, this verb:

• Cleans up all failed requests from a pool.

• Cleans up all requests from a pool.

• Cleans up failed requests for a specific user.

• Cleans up all requests for a specific user.

Format

emcli help cleanup_dbaas_requests
emcli cleanup_dbaas_requests        [-ids="<request id>"]        [-pool_name="<pool name>" -pool_type="
                     <database|schema|pluggable_database>" 
        [-user="<SSA user name>"] 
        [-all]]

[ ]  indicates that the parameter is optional.

Options

• ids

  Request ID to be used for filtering Cloud requests, separated by semicolons( ; ).

• pool_name

  Name of the pool from which requests must be cleaned up.

• pool_type

  Type of pool. Enter one of the following values:

  • For database pools: database

  • For schema pools: schema

  • For pluggable database pools: pluggable_database

• user

  User name to be used for filtering requests for deletions.

• all

  If specified, cleans up all requests (successful and failed), cancels the requests that are in a scheduled state, and leaves the requests that are in progress as is. If this option is not specified, cleanup is performed on failed requests only.

Note:

The ids and pool_name options cannot be used together.

Examples

Example 1

This example performs a cleanup of all requests, both failed and successful. This process essentially resets the pool.

emcli cleanup_dbaas_requests -pool_name="database_pool" -pool_type="database" -all

Example 2

This example performs a cleanup of all requests (failed and successful) for a specific user. This option is useful in cases where the user is no longer in the system and the administrator wants to clean up all of the service instances owned by this user.

emcli cleanup_dbaas_requests -pool_name="database_pool" -pool_type="database" -all -user="SSA_USER"