1. Command Line Interface
  2. Verb Reference
  3. EM CLI Verbs
  4. db_cloud_maintenance

db_cloud_maintenance

Performs database Cloud maintenance tasks.

db_cloud_maintenance -activateSoftware

Activates the new software of the pool.

Format

emcli db_cloud_maintenance -activateSoftware
       -pool_name= "pool_name" 
       -pool_type= "pool_type" l
       [-force= "force" ]

[ ]  indicates that the parameter is optional.

Options

  • pool_name

    The name of the pool.

  • pool_type

    The type of the pool.

  • force

    Forcibly activates new members.

Example

The following example forcibly activates new members and activates new software for the Oracle Cloud Zone pool with the name POOL.

emcli db_cloud_maintenance -activateSoftware 
      -pool_name=POOL 
      -pool_type=oracle_cloud_zone 
      -force=true

db_cloud_maintenance -performOperation

Performs a named operation on a specified pool.

Format

emcli db_cloud_maintenance -performOperation
       -name= "name"
       -description= "description"
       -purpose= "purpose" 
       -pool_name= "pool_name"
       -pool_type= "pool_type" 
        [-start_schedule= "start_schedule"]
        [-end_schedule= "end_schedule" ]
        [-input_file= "data:input_file" ]
        [-target_type= "target_type" ]
        [-target_list= "target_list" ]

[ ]  indicates that the parameter is optional.

Options

  • name

    The name of the operation.

  • description

    The description of the operation.

  • purpose

    The purpose of the operation. The possible values are: UPDATE_DB, UPDATE_RACDB, UPDATE_GI, DEPLOY_DB_SOFTWARE, DEPLOY_GI_SOFTWARE, DEPLOY_RAC_SOFTWARE, ROLLBACK_DB, ROLLBACK_GI, ROLLBACK_RACDB, and CLEANUP_SOFTWARE.

  • pool_name

    The name of the pool.

  • pool_type

    The type of the pool.

  • start_schedule

    The scheduled start time. The format for start_schedule is yyyy-MM-dd HH:mm:ss, for example start_schedule="2013-11-11 12:15:30". The default start time is immediate.

  • end_schedule

    The scheduled end time. The format for end_schedule is yyyy-MM-dd HH:mm:ss, for example end_schedule="2014-11-11 22:30:00". The default end time is indefinite.

  • input_file

    Input data for the maintenance action, for example input_file="data:~/input_files/data.

    For more information about the input_file parameter, see -input_file Syntax Guidelines.

  • target_type

    The default target type is identified based on the purpose. For example, if the purpose is DEPLOY_DB, then the default target type becomes oracle_home.

  • target_list

    A comma separated list of targets. The target list is the list of entities based on the target type that is selected. For example, if target_type=rac_database target_list,then the target list is "rac1.example.com,rac2.example.com". The default target_list is based on the purpose. For example if the purpose is DEPLOY_DB, the default target list becomes the list of Oracle homes present in the pool.

Example

The following example performs the Update RAC Database operation for the Oracle Cloud Zone pool with the name POOL.

emcli -performOperation 
      -name="Update RAC Database " 
      -description="Update RAC database Instance" 
      -purpose="UPDATE_RACDB" 
      -start_schedule="start_time:2014/09/01 00:00" 
      -end_schedule="start_time:2014/09/01 13:00" 
      -pool_name="POOL NAME" 
      -pool_type=oracle_cloud_zone 
      -target_type=rac_database 
      -target_list="rac1.example.com"

db_cloud_maintenance -relocateService

Relocates DB/PDB instance from one pool to another. You must use this verb with ‘discoverOnly’ option, to Onboard an EM managed DB/PDB on DBaaS Cloud.

Format
emcli db_cloud_maintenance –relocateService
	-input_file="data:<absolute_path_to_input_file>"
For more information on maintaining a database pool and customizing databases, see Maintaining and Customizing Databases in the Enterprise Manager Cloud Administration Guide.

Input File Properties

SRC_PDB_TARGET_NAME=<EM Target name of the PDB to be relocated>
DEST_CDB_TARGET_NAME=<EM Target name of the destination Target Container DB, optional, required when SELECT_TARGET_OPTION=RUNTIME is not used>
DEST_CDB_TARGET_TYPE=<oracle_database|rac_database>
STORAGE_LOCATION=<Optional>, Storage location for destination PDB
DEST_WORK_DIR=<Optional>, absolute path to temporary work directory at destination
SELECT_TARGET_OPTION=RUNTIME<Optional, needed if destination CDB needs to be selected automatically
DEST_CDB_POOL_NAME=<Optional>, Destination Pluggable Database Pool name needed only when SELECT_TARGET_OPTION parameter is specified
USE_SAME_STORAGE_LOCATION=Y<Optional>, needed in case PDB relocation is to be performed without moving PDB datafiles, target PDB datafile(s) storage location must also be accessible to destination Container DB
WORKLOADS=<Optional>, to be specified if during relocate, the instance needs to be associated with the different workload size. The given  workload  must exist in the Service template.
PDBAAS_CUSTOM_PRE_SCRIPTS_URN=<Optional>, if not specified, pre script configured in the Service Template associated with this instance will be selected
PDBAAS_CUSTOM_POST_SCRIPTS_URN=<Optional>, if not specified, post script configured in the Service Template associated with this instance will be selected

emcli db_cloud_maintenance –resizeService

Helps in resizing an OEM DBaaS Pluggable Database instance.

Format

emcli db_cloud_maintenance –resizeService -pdbName=”<pdb target name>”
      -workloadName=”<workload name to be used for resizing>”

Options

  • -pdbName

    Enter the pdb target name

  • -workloadName

    Enter the workload name to be used for resizing