Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


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.

See Also:


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.