Oracle DBA Question: Download Questions PDF
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
Answer:
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.
Download Oracle DBA Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What does the NO LOGGING option do? Why would we use it? Why would we be careful of using it? | What is the difference between RMAN and a traditional hotbackup? |