| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: DML operations on standby database
Answer: Can you perform DML operations when the standby database is in read only in Standby Database? |
| February 02, 2009 01:06:00 |
#2 |
| omelkoz |
Member Since: February 2009 Total Comments: 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. |
| |
Back To Question | |
