Oracle Database - pedia One of the drawbacks of a Managed Standby is that if you actually need to temporarily use the standby in a read write mode, you would have to rebuild the standby because opening the database read write requires an open reset logs, creating a new instantiation. Oracle Data Guard functionality with advanced features, allowing read-only access to data in a physical standby database to offload primary of such.
Steps to create a standby database in Oracle 11g physical standby. However in 10g and beyond, you can use flashback database to return the standby database to a point in time before you opened it read write. Steps to create a standby database in Oracle 11g physical standby database data guard concepts
ORACLE-BASE - Data Guard Physical Standby Setup in Oracle Database. "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts. Data Guard is the name for Oracle's standby database solution, used for disaster recovery and. For a backup-based duplicate, or a manual restore, take a.