1. Cloud Administration Guide
  2. Maintaining and Customizing Databases
  3. DB Relocation

36 DB Relocation

This chapter covers the database relocation feature. It contains the following sections:

Introduction

Typically, a database outlives the hosting platform. EM Database as a Service now provides support to migrate an existing database to a new DB Software Pool. This functionality will allow the DB administrators to migrate DBs to a new platform when existing platform is obsolete.

Pre-requisites

  • If the target DB is in NOARCHIVELOG mode, ARCHIVELOG mode would be enabled.

  • Oracle Home owner must be consistent across source and destination DB Software Pools.

  • PaaS Infrastructure Zone hosting the destination DB Software Pool must be different from the PaaS Infrastructure Zone hosting the DB Target.

  • DB versions for source and destination DB Software Pools must be same.

  • Destination DB Software Pool must be added to the Service Template associated with the Target DB

  • The host where you are going to relocate the source DB should also have the same listener port discovered in the EM as the source DB.

  • In case of a DB in Dataguard Standby configuration, destination DB software pool for primary DB must be added to Primary Pools in the Service template and destination DB software pool for Standby DB must be added to:

    • standby pools for the destination pool for primary database and

    • standby pools in the service template.

DB Relocation: EMCLI Command and Input File Properties

This section provides details on DB Relocation using EMCLI command:

$ emcli db_cloud_maintenance -relocateService -input_file="data:<path_to_input_file>"

Input file properties:

#Mandatory properties
SRC_TARGET_NAME=<EM target name of the srouce DB>
SRC_TARGET_TYPE=<oracle_database|rac_database>
DEST_HOST_NAME=<EM target name of the destination host>
DEST_POOL_NAME=<Destination Pool>
SRC_DB_CRED=<EM Named Credential for Target DB SYS user in the format 
CREDENTIAL_NAME:CREDENTIAL_OWNER>
#Optional properties
DELETE_SRC_TARGET=Y #If you want to delete the target DB and EM target for the target DB
DEST_TARGET_NAME=<New EM target name for the destination DB>
SELECT_ORACLE_HOME_OPTION=RUNTIME #If destination host in the destination pool is to be selected automatically
DEST_DATABASE_AREA=<absolute_path_to_destination_datafiles_location> #Only required if different at destination
DEST_FAST_RECOVERY_AREA=<absolute_path_to_destination_fast_recovery_area> #Only required if different at destination

Note:

  • This functionality is not supported for Thin Clone Database(s).

  • This is an administrator driven operation to be initiated by an EM administrator with EM_SSA_ADMINISTRATOR role privileges.