Enterprise Service Cloud - Docs

ADVANCED Plan

Q: How can I monitor the Primary/Standby configuration?

A: Oracle provides many V$-views to monitor and report Data Guard activities and status. User pdbadmin has access to these views which are available on primary database - for example:

  • V$ARCHIVE_DEST_STATUS
SELECT
    dest_id,
    dest_name,
    status,
    database_mode,
    recovery_mode,
    error
FROM
    v$archive_dest_status;
  • V$DATAGUARD_STATUS
SELECT
    facility,
    severity,
    dest_id,
    error_code,
    timestamp,
    message
FROM
    v$dataguard_status
ORDER BY timestamp DESC;
  • V$ARCHIVE_DEST
SELECT
    dest_name,
    status,
    target,
    archiver,
    error
FROM
    v$archive_dest
WHERE
    dest_name IN ( 'LOG_ARCHIVE_DEST_1', 'LOG_ARCHIVE_DEST_2' );

  • V$MANAGED_STANDBY

  • V$LOGSTDBY_TRANSACTION

  • V$STANDBY_LOG

  • V$ARCHIVE_DEST

  • V$ARCHIVE_GAP

SELECT
    thread#,
    low_sequence#,
    high_sequence#
FROM
    v$archive_gap;
  • V$DATAGUARD_CONFIG
SELECT
    db_unique_name,
    parent_dbun,
    dest_role
FROM
    v$dataguard_config;

Q: Is it possible to switchover a database on demand?

A: No.

There is no edit CDB action available to switchover a database. A switchover can be requested by a service request.

Q: Can I revert an ADVANCED configuration to a BASIC configuration?

A: No.

You have to provision a new BASIC instance and export/import the data. Support will be provided on-demand.

Q: What sync mode / protection mode is used in an ADVANCED configuration?

A: The sync mode (and the protection mode) depends on your choice during database creation.

We recommend to run the databases in SYNC (not ASYNC) mode. With SYNC every change on the primary database is automatically propagated to the standby database.

Secondly, we recommend using protection mode MaxAvailability, which means that transactions are not committed until the changes are propagated to the standby database.

During provisioning of a new database you can choose between FSFO or no-FSFO: FSFO (Fast Start Fail Over) will provide automatic switchover capability to the standby database in case there are serious problems with the primary database.

For most of our databases we recommend the following configuration:

  • Protection Mode: MaxAvailability
  • Fast-Start Failover: Enabled in Zero Data Loss Mode with 2 x Observers
  • Real Time Apply

Q: Can I open the standby database read-only?

A: No.

Nevertheless: Support to open a standby database read-only will be provided by service request.

Q: With Enterprise Edition ADVANCED, what is the benefit of enabling Fast-Start Failover (FSFO)?

A: In case of an outage (server, network, storage etc.), the primary database role switches automatically to the former standby database to the other data center. There is no manual intervention required.

Q: How are sessions handled in case of a failover/switchover?

A: In the event of a switchover/failover, open sessions are terminated, open transactions are rolled back - there is no transparent application failover (like in Oracle RAC). As soon the second side has taken over the active role, the clients can connect again.

Q: Does MODS Regular support Active Data Guard?

A: No.

Active Data Guard, and therefore features like Transaction Guard / Application Continuity, is not available in MODS Regular.

Last Updated: