Monitor the Switch

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 admin logical_status 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

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.