Tell me about standby database? What are some of the configurations of it? What should we watch out for?
Submitted by: AdministratorStandby 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
Submitted by: Administrator
Read Online Oracle DBA Job Interview Questions And Answers
Top Oracle DBA Questions
| ☺ | What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other? |
| ☺ | When using Oracle export/import what character set concerns might come up? How do you handle them? |
| ☺ | Explain FORCE LOGGING feature in 9i. |
| ☺ | Name three SQL operations that perform a SORT. |
| ☺ | What is the difference between RAID 5 and RAID 10? Which is better for Oracle? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
