Use OEM to convert to Snapshot Standby


OEM

Setup

Three systems are involved:

  1. CRONULLA
  2. PADTSOW
  3. BOTANY

Prepare for Conversion

Navigate to the Data Guard Administration page where I have the following:

OEM Data Guard Administration page

Since there is only one (1) standby database defined, there is no need to make a selection.

Click Convert .

Enter Host Credentials

Ensure that the correct host credentials are entered for where the physical standby database instance is running. In this case, that host is BOTANY :

OEM Enter host credentials for standby machine

Click Continue .

Conversion Confirmation

The following screen asks for confirmation to convert the physical standby to a snapshot standby:

OEM Confirm conversion to snapshot standby

Click Yes .

Processing: Convert Standby Database

The following progress screen appears:

OEM Processing: Convert Standby Database

Conversion Complete

When the conversion has completed successfully, the main data guard administration screen reappears with a message as follows:

OEM Conversion Complete

Note that the role has changed to Snapshot Standby .