Oracle教程 2023-04-01

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

本站中文解释

本视图显示了Automatic Storage Management (ASM) 中的ACFS 文件系统全复制的活动状态。

该视图包含以下列：

* GROUP_NUMBER： ACFS 复制组的编号。
* MEMBER_NUMBER： ACFS 复制成员的编号。
* LOCATION： ACFS 复制成员的数据库控制文件中存储的位置。
* MEMBER_TYPE：复制成员类型，有 ONLINE 和 OFFLINE 两种。
* MEMBER_STATUS：复制成员的状态，有 ACTIVE 、 QUIESCED 、 DISABLED 和 OUT_OF_SYNC 五种。

可以使用该视图来检查 ACFS 复制成员的状态，以及判断复制组中的复制成员是否存在状态不同步的情况。

官方英文解释

V$ASM_ACFSREPL displays information for Oracle ACFS file systems that are initialized for replication.

Column	Datatype	Description
`FSNAME`	`VARCHAR2(1024)`	File system mount point (foreign key to `V$ASM_FILESYSTEM`)
`VOLDEV`	`VARCHAR2(256)`	Name of the Oracle ADVM device
`SITE`	`VARCHAR2(7)`	Replication site role: `PRIMARY` – File system is initialized as a primary `STANDBY` – File system is initialized as a standby
`LAG`	`VARCHAR2(128)`	Amount of time standby is behind primary in hours:minutes:seconds (primary only)
`STATUS`	`VARCHAR2(12)`	Replication primary or standby status: `ONLINE` – Replication is initialized and processing real-time changes `INITIALIZING` – Replication is still processing files on the primary that existed before replication started `PAUSED` – The primary is not sending logs to the standby or the standby is not applying logged changes
`INITSTATUS`	`VARCHAR2(11)`	Replication primary or standby initialization status: `NONE` – Replication is `ONLINE` and not initializing `DIRECTORIES` – Directories are being initialized `FILES` – Files are being initialized
`DIRSSCAN`	`NUMBER`	Number of directories scanned and logged (primary only)
`PERCENT`	`NUMBER`	Percentage of files initialized that existed before replication started (primary only)
`LASTSYNC`	`DATE`	Time of last apply on the standby site (standby only)
`CRSRUN`	`NUMBER`	Number of Cluster Ready Services replication daemons currently running
`CRSTOTAL`	`NUMBER`	Number of Cluster Ready Services replication daemons expected to be running
`PMNTPT`	`VARCHAR2(1024)`	Replication primary site mount point
`SMNTPT`	`VARCHAR2(1024)`	Replication standby site mount point
`PSVCNAME`	`VARCHAR2(1024)`	Replication primary site service name
`SSVCNAME`	`VARCHAR2(1024)`	Replication standby site service name
`PHOST`	`VARCHAR2(1024)`	A replication primary cluster host name
`SHOST`	`VARCHAR2(1024)`	A replication standby cluster host name
`REMALIAS`	`VARCHAR2(4096)`	Replication remote alias name
`TAGS`	`NUMBER`	`TRUE` (`1`) if replicating tagged files
`COMPRESSION`	`VARCHAR2(3)`	Replication log compression status: `OFF` – Replication logs are not being compressed `ON` – Replication logs are being compressed
`DBGLVL`	`NUMBER`	Replication trace log debug level
`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 For this view, the value is always `0`.

Note:

This view only contains records for Oracle ASM releases prior to Oracle Database 12c Release 2 (12.2.0.1). To display Oracle ACFS replication information for Oracle Database 12c Release 2 (12.2.0.1) or higher, use the acfsutil repl info command.

本站中文解释

官方英文解释

相关推荐