Hello,
I have a question about Oracle 12 snapshot standby to physical standby using data guard broker.
I can convert the physical standby database (server B) to snapshot standby database (running the command in standby database, server B).
However, when I tried to convert the snapshot standby back to physical standby, I found that I had to run the command in primary database server (server A).
When I run this in the snapshot standby database server (server B), it failed
DGMGRL> show configuration;
Configuration - orcl_dataguard
Protection Mode: MaxAvailability
Members:
orcl - Primary database
orcl_dr - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 48 seconds ago)
DGMGRL> convert database 'orcl_dr' to physical standby;
Converting database "orcl_dr" to a Physical Standby database, please wait...
Error:
ORA-03113: end-of-file on communication channel
Process ID: 7623
Session ID: 273 Serial number: 16771
Failed to convert database "orcl_dr"
-----------------------------------------------------------------------------
- Below is the steps to resume:
My question is that is this normal?
Please note this problem occur in 12.1.0.2 and also after they are patched to 12.1.0.2 with 2016 July PSU .
Thanks.
1. restart snapshot standby database
2. After a while.
3. DGMGRL> show configuration
Configuration - orcl_dataguard
Protection Mode: MaxAvailability
Members:
orcl - Primary database
orcl_dr - Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 28 seconds ago)
4. Then run the command in the primary database server (server A).
DGMGRL> convert database 'orcl_dr' to physical standby;
Converting database "orcl_dr" to a Physical Standby database, please wait...
Oracle Clusterware is restarting database "orcl_dr" ...
Continuing to convert database "orcl_dr" ...
Database "orcl_dr" converted successfully
5. After a while:
DGMGRL> show configuration
Configuration - orcl_dataguard
Protection Mode: MaxAvailability
Members:
orcl - Primary database
orcl_dr - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 9 seconds ago)