RA_REPLICATION_DATABASE

This view lists information on replication servers and protected databases.

Column Data Type NULL Description
DB_UNIQUE_NAME VARCHAR2(128)   The unique name of the protected database.
DB_KEY NUMBER NOT NULL The primary key for this protected database in the Recovery Appliance metadata database.
REPLICATION_SERVER_NAME VARCHAR2(128) NOT NULL The user-assigned name of the replication server.
REPLICATION_SERVER_KEY NUMBER NOT NULL Cross reference to other RA_* views and server.server_key.
REPLICATION_SERVER_STATE VARCHAR2(18)  

The possible replication server status are:

  • AVAILABLE
  • CREATING
  • DELETING
  • TESTING CONNECTION
  • RUNNING
  • PAUSED
  • ERROR STATE
REPLICATION_DATABASE_STATE VARCHAR2(7) NOT NULL

The possible database replication status are:

  • AVAILABLE
  • CREATING
  • DELETING
  • TESTING CONNECTION
  • RUNNING
  • PAUSED
  • ERROR STATE
  • null
POLICY_NAME VARCHAR2(128) NOT NULL The protection policy that is associated with this replication server and database.
FAILURE_CNT NUMBER NOT NULL The number of conseceutive failures this database has had replicating to this replication server.
LAST_RECONCILE TIMESTAMP(6) WITH TIME ZONE   The time of the last successful reconcile for this database and replication server.
NEXT_RECONCILE TIMESTAMP(6) WITH TIME ZONE   The time of the next reconcile for this database and replication server.
LAST_REPLICATION TIMESTAMP(6) WITH TIME ZONE   The time of the last successful replication for this database and replication server.
PENDING_REPLICATION_SETUP VARCHAR2(3)  

If YES, an initial connection, reconcile and replication is still pending.

If NO, initial replication setup is complete.

FIXED_SECTION_UPDATE TIMESTAMP(6) WITH TIME ZONE   The time of the most recent fixed section update from the client database that has not yet been reconciled to this replication server.
REP_RSDB_KEY NUMBER NOT NULL Cross reference to other RA_* views
REP_SERVER_KEY NUMBER NOT NULL Cross reference to other RA_* views