Cannot disable configuration due to ORA-16623: database detected role change; ORA-16625: cannot reac
edited Feb 25, 2013 3:39AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 commentsAnswered ✓
Hi,
I have setup primary 'prd1108' and physical standby 'p1108sb1' successful and switchover successful. Then switchback letting 'prd1108' to be primary.
I am working on creating another logical standby 'p1108sb2' for reporting purpose.
Something wrong in the middle then I remove the 'p1108sb2' from primary parameter log_archive_config from 'DG_CONFIG=(prd1108,p1108sb1,p1108sb2)' to 'DG_CONFIG=(prd1108,p1108sb1)'. I haven't added the database 'p1108sb2' into DGMGRL configuration.
Now, from primary node:
DGMGRL> connect sys/<password>;
Connected.
DGMGRL> show configuration;
Configuration - dg4prd1108
0