gyanjit

 Profile Answers by gyanjit 

• Nov 19th, 2008

 

We can't do the DML on the physical standby DB , it is Read only,

omelkoz

 Profile Answers by omelkoz 

• Feb 28th, 2009

 

Standby can be of two types, physical standby and logical standby.

Physical standby database is exactly the same in structure as primary database. When it is in read-only mode, SQL queries can be run on it. The other mode is redo-apply mode and database is not accessible for queries at that time.

Logical standby database may have different structure from primary database. When it is in read-only mode, SQL statements generated from redo are applied and queries may be run concurrently. When in read-write mode, one can modify data in tables created in addition to primary schema. But this setting may be over written by specifying additional security options.

aravindhreturns

 Profile Answers by aravindhreturns 

• Jul 7th, 2009

 

I agree with omelkoz, But I need to add a small point here. Specifying STANDBY is to to prevent all users other than SYS from making DML and DDL changes to any table or sequence being maintained through SQL apply operations. Not everybody can execute statements on a standby. :)

cmanne

 Profile Answers by cmanne 

• Sep 2nd, 2009

 

In a nutshell, One can do SELECTS only on a Physical/Logical Standby database. The basic principle behind Oracle Standby database is to provide protection against media failures. So no DMLs are allowed on the standby database and the most important things is that Standby databases can always be opened in READ-ONLY mode which won't allow DMLs.