Data guard-snapshot Standby Database configuration

Reprinted from: Https://blogs.oracle.com/Database4CN/entry/data_guard_snapshot_standby_database

Overview In general, the physical standby database is in the Mount state to receive and apply the redo log of the main library, and the physical standby database cannot provide access externally. If you need read-only access, you can temporarily open the physical standby in read-only mode, or configure active DATA GUARD, then the physical standby database can be read-only (read-only) access (such as Report business query), However, the physical standby database cannot read and write operations (Read-write).

In some cases, in order to implement a system stress test or a real application testing (RAT) or other read-write operation test, you can temporarily convert the physical standby database to a snapshot standby database and then test it. Because the snapshot standby database is independent of the main library, it is possible to read and write operations (Read-write). During the test, the snapshot standby database normally receives the archive log of the main library, ensures the data security of the main library, but does not apply these logs, when the stress test is finished, it is very simple to convert the snapshot standby to the physical standby database. Continue synchronizing the main library log.

Data guard-snapshot Standby Database configuration