oci_database_migration_job

This resource provides the Job resource in Oracle Cloud Infrastructure Database Migration service.

Update Migration Job resource details.

Note: If you wish to use the DMS deprecated API version /20210929 it is necessary to pin the Terraform Provider version to v5.47.0. Newer Terraform provider versions will not support the DMS deprecated API version /20210929

Example Usage

resource "oci_database_migration_job" "test_job" {
	#Required
	job_id = oci_database_migration_job.test_job.id

	#Optional
	defined_tags = {"foo-namespace.bar-key"= "value"}
	display_name = var.job_display_name
	freeform_tags = var.job_freeform_tags
}

Argument Reference

The following arguments are supported:

• defined_tags - (Optional) (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
• display_name - (Optional) (Updatable) Name of the job.
• freeform_tags - (Optional) (Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {“Department”: “Finance”}
• job_id - (Required) The OCID of the job
• suspend_trigger - (Optional) (Updatable) An optional property when incremented triggers Suspend. Could be set to any integer value.

** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

Attributes Reference

The following attributes are exported:

• collect_traces_data - Information regarding the DB trace and alert log collection
  • bucket - Name of the bucket containing the file.
  • collect_traces_state - Status of trace collection process.
  • namespace - Object Storage namespace.
  • object - Object name.
• defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
• display_name - Name of the job.
• freeform_tags - Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {“Department”: “Finance”}
• id - The OCID of the Migration Job.
• lifecycle_details - A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.
• migration_id - The OCID of the Migration that this job belongs to.
• parameter_file_versions - A list of parameter file versions that can be viewed or edited for the current job.
  • defined_tags - Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
  • description - A description to discribe the current parameter file version
  • freeform_tags - Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {“Department”: “Finance”}
  • is_current - Return boolean true/false for the currently in-use parameter file (factory or a versioned file)
  • is_factory - Return true/false for whether the parameter file is oracle provided (Factory)
  • kind - Indicator of Parameter File ‘kind’ (for an EXTRACT or a REPLICAT)
  • name - A unique name associated with the current migration/job and extract/replicat name
  • system_tags - Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
  • time_created - The time when this parameter file was applied on the process
• progress - Progress details of a Migration Job.
  • current_phase - Current phase of the job.
  • current_status - Current status of the job.
  • phases - List of phase status for the job.
    • action - The text describing the action required to fix the issue
    • duration_in_ms - Duration of the phase in milliseconds
    • editable_parameter_files - Attribute that returns an array of names and types of GoldenGate configuration files that are available for read or update.
    • extract - Summary of phase status results.
      • message - Message in entry.
      • type - Type of extract.
    • is_advisor_report_available - True if a Pre-Migration Advisor report is available for this phase. False or null if no report is available.
    • is_suspend_available - This is returned as true if the current phase can be suspended.
    • issue - The text describing the root cause of the reported issue
    • log_location - Details to access log file in the specified Object Storage bucket, if any.
      • bucket - Name of the bucket containing the log file.
      • namespace - Object Storage namespace.
      • object - Log object name.
    • name - Phase name
    • progress - Percent progress of job phase.
    • status - Phase status
• state - The current state of the migration job.
• system_tags - Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
• time_created - The time the Migration Job was created. An RFC3339 formatted datetime string
• time_updated - The time the Migration Job was last updated. An RFC3339 formatted datetime string
• type - The job type.
• unsupported_objects - Database objects not supported.
  • object - Name of the object (regular expression is allowed)
  • owner - Owner of the object (regular expression is allowed)
  • type - Type of unsupported object

Timeouts

The timeouts block allows you to specify timeouts for certain operations: * create - (Defaults to 20 minutes), when creating the Job * update - (Defaults to 20 minutes), when updating the Job * delete - (Defaults to 20 minutes), when destroying the Job

Import

Jobs can be imported using the id, e.g.

$ terraform import oci_database_migration_job.test_job "id"