You can use admin logical_status to check for replication system problems that prevent the switch from proceeding. Such problems may include a full transaction log for the standby database or a suspended standby DSI. If you cannot resolve the problems, you can abort the switch using the abort switch command.
The Operation in Progress and State of Operation in Progress output columns indicate the switch status.
For example, suppose the admin logical_status command persistently returns one of the following messages in its State of Operation in Progress output column:
Standby has some transactions that have not been applied
or
Inbound Queue has not been completely read by Distributor
These messages may indicate a problem that you cannot resolve, in which case you may choose to abort the switch. You can use admin who commands to obtain more information about the state of the switching operation.
See “Commands for monitoring warm standby applications” for more information.
