Oracle 视图 V$COPY_NONLOGGED 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$COPY_NONLOGGED提供以下有关正在进行的非归档拷贝操作（COPY nonlogged）的信息。
此视图是从对象$KTCNlist中创建的。$KTCNlist保存正在进行的拷贝操作的全局信息。
用途：用于跟踪正在进行的非归档拷贝操作（COPY nonlogged），并跟踪它们的进度。
使用方法：可以使用SELECT语句查询视图V$COPY_NONLOGGED来获取正在进行的COPY nonlogged操作的实时信息。例如，可以使用以下语句查看正在进行的无归档拷贝操作：
SELECT * FROM V$COPY_NONLOGGED;
官方英文解释
V$COPY_NONLOGGED displays information about nonlogged block ranges in data file copy blocks, recorded in the control file.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Instance ID |
|
|
|
Nonlogged copy record ID |
|
|
|
Nonlogged copy record stamp |
|
|
|
Data file copy record ID |
|
|
|
Data file copy record stamp |
|
|
|
Absolute file number of the data file that contains this range of nonlogged blocks |
|
|
|
Block number of the first nonlogged block in the range of nologged blocks |
|
|
|
Number of nonlogged blocks found starting with |
|
|
|
The smallest SCN on which any block in this block range became nonlogged. NULL if unknown. |
|
|
|
The time that corresponds to |
|
|
|
The resetlogs SCN of the incarnation on which this block range was first marked as nonlogged. NULL if unknown. |
|
|
|
The resetlogs time of the incarnation on which this block range was first marked as nologged. NULL if unknown. |
|
|
|
The object ID this range belongs to. If this field is NULL, the object number is unknown. |
|
|
|
The reason why this block range appears in this list, for example, primary file offline, could not talk to primary, non-standby recovery, and so on. For Oracle Database 12c and later releases, it is always |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
