Use DGMGRL to convert to Snapshot Standby

Summary

The reference is 6.13 Scenario 12: Converting a Physical Standby to a Snapshot Standby .

References

Oracle Manuals

Oracle ^® Data Guard Broker 12c Release 1 (12.1)

6 Scenarios Using the DGMGRL Command-Line Interface

6.13 Scenario 12: Converting a Physical Standby to a Snapshot Standby

7 Oracle Data Guard Command-Line Interface Reference

Oracle ^® Data Guard Concepts and Administration 12c Release 1 (12.1)

6 Oracle Data Guard Protection Modes

Procedure Using DGMGRL

Connect to Data Guard Manager

Use the dgmgrl command to connect to the local Data Guard Manager as follows:

dgmgrl sys/**********

Sample output is:

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected as SYSDG.

Verify Configuration

Use the following command to ensure that:

Protection mode is Maximum Performance because we are running a single standby.
Fast Start Failover is disabled.
Primary database is open for Read/Write
Physical Standby is mounted
There are no warnings or errors

show configuration

The expected output is similar:

Configuration - ocm12.yaocm.id.au

  Protection Mode: MaxPerformance
  Members:
  ocm12        - Primary database
    ocm12_botany - Physical standby database 

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 51 seconds ago)

Convert to Snapshot Standby

Use the following command to convert the physical standby database into a snapshot standby:

convert database ocm12_botany to snapshot standby;

The expected output is:

Converting database "ocm12_botany" to a Snapshot Standby database, please wait...
Database "ocm12_botany" converted successfully

NOTE:
If the password provided for connection is incorrect, the following messages will appear:

Converting database "ocm12_botany" to a Physical Standby database, please wait...
Operation requires shut down of instance "ocm12" on database "ocm12_botany"
Shutting down instance "ocm12"...
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

Please complete the following steps and reissue the CONVERT command:
	shut down instance "ocm12" of database "ocm12_botany"
	start up and mount instance "ocm12" of database "ocm12_botany"

Verify Configuration

Use the following command to verify

show configuration

The expected output is:

Configuration - ocm12.yaocm.id.au

  Protection Mode: MaxPerformance
  Members:
  ocm12        - Primary database
    ocm12_botany - Snapshot standby database 

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 6 seconds ago)