can I use sqlplus to switchover when dataguard broker is turned on?
edited Dec 16, 2015 10:40PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 5 commentsAnswered ✓
hi,
My switcover command failed.
DGMGRL>switchover to 'p1c2d66';
Error: ORA-16775: target standby database in broker operation has potential data loss
Failed.
Unable to switchover, primary database is still "p1c2d67"
My question is,can I use the sqlplus instead of DGMGRL when dg_broker_start=true? e.g :
on primary: SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
on standby: SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;
I suspect that I changed the password on primary day before.
Thank You
0