pdb_conversion_history_entries

Creates, updates, deletes, gets or lists a pdb_conversion_history_entries resource.

Overview

Name	pdb_conversion_history_entries
Type	Resource
Id	oci.database.pdb_conversion_history_entries

Fields

The following fields are returned by SELECT queries:

get

The pluggable database conversion history.

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the database conversion history.
action	string	The operations used to convert a non-container database to a pluggable database. - Use PRECHECK to run a pre-check operation on non-container database prior to converting it into a pluggable database. - Use CONVERT to convert a non-container database into a pluggable database. - Use SYNC if the non-container database was manually converted into a pluggable database using the dbcli command-line utility. Databases may need to be converted manually if the CONVERT action fails when converting a non-container database using the API. - Use SYNC_ROLLBACK if the conversion of a non-container database into a pluggable database was manually rolled back using the dbcli command line utility. Conversions may need to be manually rolled back if the CONVERT action fails when converting a non-container database using the API. (PRECHECK, CONVERT, SYNC, SYNC_ROLLBACK)
additionalCdbParams	string	Additional container database parameter.
cdbName	string	The database name. The name must begin with an alphabetic character and can contain a maximum of 8 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.
lifecycleDetails	string	Additional information about the current lifecycle state for the conversion operation.
lifecycleState	string	Status of an operation performed during the conversion of a non-container database to a pluggable database. (SUCCEEDED, FAILED, IN_PROGRESS)
sourceDatabaseId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the database.
target	string	The target container database of the pluggable database created by the database conversion operation. Currently, the database conversion operation only supports creating the pluggable database in a new container database. - Use NEW_DATABASE to specify that the pluggable database be created within a new container database in the same database home. (NEW_DATABASE)
targetDatabaseId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the database.
timeEnded	string (date-time)	The date and time when the database conversion operation ended.
timeStarted	string (date-time)	The date and time when the database conversion operation started.

list

Details of operations performed to convert a non-container database to pluggable database.<br />

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the database conversion history.
action	string	The operations used to convert a non-container database to a pluggable database. - Use PRECHECK to run a pre-check operation on non-container database prior to converting it into a pluggable database. - Use CONVERT to convert a non-container database into a pluggable database. - Use SYNC if the non-container database was manually converted into a pluggable database using the dbcli command-line utility. Databases may need to be converted manually if the CONVERT action fails when converting a non-container database using the API. - Use SYNC_ROLLBACK if the conversion of a non-container database into a pluggable database was manually rolled back using the dbcli command line utility. Conversions may need to be manually rolled back if the CONVERT action fails when converting a non-container database using the API. (PRECHECK, CONVERT, SYNC, SYNC_ROLLBACK)
additionalCdbParams	string	Additional container database parameter.
cdbName	string	The database name. The name must begin with an alphabetic character and can contain a maximum of 8 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.
lifecycleDetails	string	Additional information about the current lifecycle state for the conversion operation.
lifecycleState	string	Status of an operation performed during the conversion of a non-container database to a pluggable database. (SUCCEEDED, FAILED, IN_PROGRESS)
sourceDatabaseId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the database.
target	string	The target container database of the pluggable database created by the database conversion operation. Currently, the database conversion operation only supports creating the pluggable database in a new container database. - Use NEW_DATABASE to specify that the pluggable database be created within a new container database in the same database home. (NEW_DATABASE)
targetDatabaseId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the database.
timeEnded	string (date-time)	The date and time when the database conversion operation ended.
timeStarted	string (date-time)	The date and time when the database conversion operation started.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	databaseId, pdbConversionHistoryEntryId, region	opc-request-id	Gets the details of operations performed to convert the specified database from non-container (non-CDB) to pluggable (PDB).<br />
list	select	databaseId, region	pdbConversionAction, lifecycleState, sortBy, sortOrder, opc-request-id, limit, page	Gets the pluggable database conversion history for a specified database in a bare metal or virtual machine DB system.<br />

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
databaseId	string	The database [OCID](/Content/General/Concepts/identifiers.htm).
pdbConversionHistoryEntryId	string	The database conversion history [OCID](/Content/General/Concepts/identifiers.htm).
region	string	OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
lifecycleState	string	A filter to return only the pluggable database conversion history entries that match the specified lifecycle state. For example, you can use this filter to return only entries in the "failed" lifecycle state.
limit	integer	The maximum number of items to return per page.
opc-request-id	string	Unique identifier for the request.
page	string	The pagination token to continue listing from.
pdbConversionAction	string	A filter to return only the pluggable database conversion history entries that match the specified conversion action. For example, you can use this filter to return only entries for the precheck operation.
sortBy	string	The field to sort by. You can provide one sort order (sortOrder). The default order for TIMECREATED is ascending.
sortOrder	string	The sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples

get

Gets the details of operations performed to convert the specified database from non-container (non-CDB) to pluggable (PDB).<br />

SELECT
id,
action,
additionalCdbParams,
cdbName,
lifecycleDetails,
lifecycleState,
sourceDatabaseId,
target,
targetDatabaseId,
timeEnded,
timeStarted
FROM oci.database.pdb_conversion_history_entries
WHERE databaseId = '{{ databaseId }}' -- required
AND pdbConversionHistoryEntryId = '{{ pdbConversionHistoryEntryId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

list

Gets the pluggable database conversion history for a specified database in a bare metal or virtual machine DB system.<br />

SELECT
id,
action,
additionalCdbParams,
cdbName,
lifecycleDetails,
lifecycleState,
sourceDatabaseId,
target,
targetDatabaseId,
timeEnded,
timeStarted
FROM oci.database.pdb_conversion_history_entries
WHERE databaseId = '{{ databaseId }}' -- required
AND region = '{{ region }}' -- required
AND pdbConversionAction = '{{ pdbConversionAction }}'
AND lifecycleState = '{{ lifecycleState }}'
AND sortBy = '{{ sortBy }}'
AND sortOrder = '{{ sortOrder }}'
AND opc-request-id = '{{ opc-request-id }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;