Difference between clustering and mirroring

Ask a question
          

Difference between clustering and mirroring

<<Previous   Next>>

Oracle - Difference between clustering and mirroring - April 16, 2010 at 18:55 pm by Shuchi Gauri

Difference between clustering and mirroring 

Clustering means one than one database server configured for the same user connection. When users connect, one of the server’s responds and connects based on availability. The user is completely ignorant of the fact that there are more than one database servers. It demands high cost due to infrastructure needs. Clustering is hence done on server level.

Mirroring means, one has many configured databases on the same server. Mirrors are basically copies of the original database. Mirroring is hence done on database level. 

<<Previous   Next>> 
Difference between hot backup & cold backup

A cold backup is done when there is no user activity going on with the system. Also called as offline backup, is taken when the database is not running and no users are logged in........

Oracle database tuning

Automatic Performance Diagnostic and Tuning Features, Automatic Shared Memory Management - Automatic Shared Memory Management puts Oracle in control of allocating memory within the SGA..........

Oracle constraints

Explain the constraints that can be applied to Oracle tables, Explain various types of constraints in Oracle, What is an integrity constraint?.................

Oracle Backup and Recovery

What is configure command and recovery catalog?, What are different types of backup? (Hot, Cold, logical, Physical)?, Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?................ 



Write your comment - Share Knowledge and Experience


 

 
Interview questions
 
Home | Login | About us | Sitemap | Contact us