Enable Flashback Database for the PeopleSoft Databases in OCI

It is an Oracle MAA best practice to enable Flashback Database for both of the PeopleSoft databases you just configured in OCI.

Flashback Database provides the following benefits:
  • Reinstate a failed primary database without copying from the new primary or restoring from a backup.
  • Flash the physical standby back for investigative work.
There are three steps to perform on each of the physical standby databases to enable Flashback Database:
  1. Disable redo apply
  2. Enable Flashback Database
  3. Re-enable redo apply

Disable redo apply

Disable redo apply on each of the physical standby databases. This example uses the database CDBHCM_iad1dx.
  1. Log into one of the Oracle Exadata Database Service on Dedicated Infrastructure domUs hosting the standby database and become oracle.
  2. Source the PeopleSoft database.
    $ ./CDBHCM.env
  3. Log into the Data Guard Broker command-line interface as SYS, then issue the following command to disable redo apply.
    DGMGRL> edit database CDBHCM_iad1dx set state='apply-off';
    Succeeded.
  4. Exit Data Guard Broker.

Enable Flashback Database

Perform the following on each of the physical standby databases to enable Flashback Database:

  1. Start an SQL*Plus session as sysdba.
  2. Enable Flashback Database.
    $ sqlplus / as sysdba
    SQL> alter database flashback on; 
    Database altered. 
    Exit SQL*Plus

Enable redo apply

Enable redo apply on each of the physical standby databases. This example uses the database CDBHCM_iad1dx.
  1. Log into the Data Guard Broker command-line interface as SYS.
  2. Issue the following command to enable redo apply.
    DGMGRL> edit database CDBHCM_iad1dx set state='apply-on';
    Succeeded.
  3. Exit Data Guard Broker.