You might want to shut off HotStandby operations temporarily in the Primary server, for example, if you are taking the Secondary server out of service to upgrade it and the Primary does not have enough disk space to store the transaction logs that accumulates while the Secondary is out of service.
1 Disconnect the servers (if they are currently connected).
2 Set the Primary server to STANDALONE state, using the following sequence of commands:
ADMIN COMMAND 'hotstandby disconnect'; -- if servers are connected ADMIN COMMAND 'hotstandby set standalone';
The Primary server continues to operate as a non-HotStandby server.
Note After you have stopped storing transaction logs to send to the Secondary, you can no longer have the Primary and Secondary servers catch up merely by connecting them again. Instead, you must synchronize the servers manually when you resume HotStandby operations.