V$ASM_ACFSREPL

7.48 V$ASM_ACFSREPL

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.