Hot standby database
With the hot standby database, you actually use only one database at a time. The second database is constantly in recovery mode. As an archived redo log file is generated, it is copied over to the remote site and applied to the database. In the event of a failure of the primary database, you complete the recovery process and bring up the standby database.
With this facility, you will have to maintain redundant computer and storage systems, and in the case of a recovery, you will have lost any committed transactions that have not been moved to an archived log file. However, you will not need to maintain a high-speed communication line between the databases as you must with replication. In fact, the connection does not even have to be continuous.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access