Oracle教程

Oracle 视图 V$ASM_DBCLONE_INFO 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$ASM_DBCLONE_INFO是一个动态性能视图，用于跟踪Automatic DB Cloning (ADC) 进程中的状态信息，其视图包含了有关ADC进程的各种信息，包括ADC配置，ADC分组信息，源实例状态，ADC实例状态，以及操作（如收益和完成）等信息。该视图可以帮助用户查看正在运行的ADC任务的情况，并可以通过ASMCMD间接调用来查看相应的结果数据。

使用Oracle视图V$ASM_DBCLONE_INFO时，需要先执行sqlnet网络管理员权限许可证，然后在终端中输入一个带有双引号引用符的SELECT语句，以检索使用SELECT * FROM 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

See Also:

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


数据运维技术 » Oracle 视图 V$ASM_DBCLONE_INFO 官方解释，作用，如何使用详细说明
分享到：

相关推荐