7.57 V$ASM_DBCLONE_INFO

V$ASM_DBCLONE_INFO shows the relationship between the parent database and point-in-time database clones.

Column Datatype Description

GROUP_NUMBER

NUMBER

Disk group number

DBCLONE_NAME

VARCHAR2(128)

Name of the point-in-time database clone

MIRRORCOPY_NAME

VARCHAR2(128)

Name of the mirror copy associated with the database clone

DBCLONE_STATUS

VARCHAR2(128)

Status of the database clone. Possible values:

  • PREPARING — The process to prepare the database for splitting has started, but the database is not yet ready to be split.

  • PREPARED — The preparation process is complete and the database is ready to be split.

  • SPLITTING — The process to split the database files has started.

  • SPLIT COMPLETED — The database has been split.

  • DROPPING — The process to drop the prepared database clone has started.

  • FAILED — The clone operation has failed. The incomplete clone will be dropped.

PARENT_DBNAME

VARCHAR2(128)

Name of the parent database

PARENT_FILEGROUP_NAME

VARCHAR2(128)

Name of the file group associated with the parent database

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle Database release 18c, version 18.1.

See Also:

Oracle Automatic Storage Management Administrator's Guide for information about point-in-time database clones