Http www oracle com technetwork database upgrade 11gr2 upgrade. 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. Although a manual upgrade gives finer control over the upgrade process, it is more. Beginning with Oracle Database 11g, Data Guard physical standby.
Creating a Physical Standby Database 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. The steps described in this chapter confure the standby database for maximum performance mode, which is the default. See Oracle Database SQL Reference.
ORACLE DBA Knowledge Share Clone the database and make standby. "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts. Create the oracle password file in the clone database oracle_home. complete, but does not place the standby database in manual or managed recovery mode.