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

  • PAUSED - The primary is not sending logs to the standby or the standby is not applying logged changes

INITSTATUS VARCHAR2(11) This column is not maintained.
DIRSSCAN NUMBER This column is not maintained.
PERCENT NUMBER This column is not maintained.
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) This column is not maintained.
SSVCNAME VARCHAR2(1024) This column is not maintained.
PHOST VARCHAR2(1024) A replication primary cluster host name
SHOST VARCHAR2(1024) A replication standby cluster host name
REMALIAS VARCHAR2(4000) This column is not maintained.
TAGS NUMBER TRUE (1) if replicating tagged files
COMPRESSION VARCHAR2(3) This column is not maintained.
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: For Oracle ASM releases 12.2 or later, this view contains records only for storage locations that are file systems (and not for storage locations that are snapshots). The following columns in this view are no longer maintained: INITSTATUS, DIRSCAN, PERCENT, PSVCNAME, SSVCNAME, REMALIAS, and COMPRESSION.

See Also:

Note: To display information about Oracle ACFS file systems or volumes that are located on nodes in an Oracle Flex ASM configuration, you must connect to the Oracle ASM proxy instance instead of the local Oracle ASM instance. For information about Oracle Flex ASM, refer to Oracle Automatic Storage Management Administrator’s Guide.