Category Archives: Physical Standby

Archive Logs in $ORACLE_HOME/dbs

This has been happening over the years but I couldn’t figure out why….finally found this article on My Oracle Support (MOS):  Setup Local archiving on standby to Prevent Logs sent to $ORACLE_HOME/dbs (on both GRID and SQLPLUS) (Doc ID 1271095.1) … Continue reading

Posted in 11g, DATA GUARD, MOS, my oracle support, oracle, Physical Standby, RMAN, standby, Uncategorized | Leave a comment

Creating Standby with Active Database Duplication in 11gR2 or also known as Wading through the MOS

Several errors prevented the creation of a physical standby database ( in a DataGuard configuration using the High Availability Console in Grid Control…finally resorted to manual methods to finish the task.  A combination of DATAGUARD command-line, SQLPLUS and RMAN.  … Continue reading

Posted in 11g, DATA GUARD, grid control, my oracle support, Physical Standby, RMAN | 1 Comment

Monitoring the Physical Standby Progress

In order to be able to fail over to a physical standby…you must be assured that the REDO data being shipped is being applied. I run a script daily on all databases involved in a DATAGUARD configuration to check for any … Continue reading

Posted in DATA GUARD, Logical Standby, Physical Standby | Tagged , , | 2 Comments

11g Snapshot Database

A new feature called the Snapshot DATABASE in 11g reduces the amount of manual steps in previous versions to accomplish the same tasks.   See other posts about DATAGUARD and FLASHBACK.  This allows you to use a physical standby for all sorts of tasks … Continue reading

Posted in 11g, DATA GUARD, FLASHBACK, Physical Standby, Recovery | Tagged | Leave a comment

ORA-16191- Applicable to Streams, DATA GUARD Errors in 11g

This feature is apparently still true in version….just verified it. Couldn’t add the database using OEM just produced errors that don’t show up when searching MOS. I then used Data Guard Manager command-line utility as it tends to produce … Continue reading

Posted in DATA GUARD, Physical Standby | Tagged , , | 2 Comments


SQLPLUS commands to turn off DATA GUARD temporarily in order to activate the physical standby for testing purposes.  Notice commands are indicated by PRMY or STBY designation for which database they need to executed on.  11g reduces these steps making … Continue reading

Posted in DATA GUARD, FLASHBACK, Physical Standby | Tagged , | 1 Comment

Commodity Hardware and Multiple Disaster Recovery Sites

Our organization utilizes inexpensive commodity hardware where the trade-off for less durability is compensated by running more standbys. This reduced our costs overall while ensuring a more robust testing and disaster recovery environment. Along with the fact that certain DATA … Continue reading

Posted in DATA GUARD, Physical Standby | Leave a comment