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.
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........
Automatic Performance Diagnostic and Tuning Features, Automatic Shared Memory
Management - Automatic Shared Memory Management puts Oracle in control of
allocating memory within the SGA..........
Explain the constraints that can be applied to Oracle tables, Explain various
types of constraints in Oracle, What is an integrity
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?................