Oracle DBA Interview Question:

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

Submitted by: Administrator

Standby databases allow us to create a copy of our production db, for disaster recovery. We merely switch mode on the target db, and bring it up as read/write. Can setup as master->slave or master->master. The latter allows the former prod db to become the standby, once the failure cause is remedied. Watch out for NO LOGGING!! Be sure we're in archivelog mode.
Submitted by: Administrator