Oracle DBA Question: Download Oracle DBA 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.
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? |