Database Administration - DML operations on standby database

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 226 of 231

DML operations on standby database

Can you perform DML operations when the standby database is in read only in Standby Database?

Total Answers and Comments: 4

Last Update: September 02, 2009 Asked by: narsinghv

Sponsored Links

Best Rated Answer

—

Submitted by: omelkoz

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.

Above answer was rated as good by the following members:
aravindhreturns

November 19, 2008 15:08:40

gyanjit

Member Since: November 2008 Contribution: 1

RE: DML operations on standby database

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

February 28, 2009 01:06:00

omelkoz

Member Since: February 2009 Contribution: 1

RE: DML operations on standby database

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 07, 2009 01:43:19

aravindhreturns

Member Since: July 2009 Contribution: 5

RE: DML operations on standby database

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. :)

Is this answer useful? Yes | No

September 02, 2009 17:42:15

cmanne

Member Since: January 2006 Contribution: 49

RE: DML operations on standby database

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank