Difference between Cloning and Standby databases

What is the difference between Cloning and Standby databases?

The clone database is a copy of the database which can be opened in read write mode. It is treated as a separate copy of the database that is functionally completely separate. The standby database is a copy of the production database used for disaster protection. In order to update the standby database; archived redo logs from the production database can be used. If the primary database is destroyed or its data becomes corrupted, one can perform a failover to the standby database, in which case the standby database becomes the new primary database.
Why use materialized view instead of a table?
Why use materialized view instead of a table? - Materialized views are basically used to increase query performance since it contains results of a query.....
Why and how the deadlock situation arises.
Why and how the deadlock situation arises? - A deadlock situation arises when two or more users wait for the same resource locked by one anther.....
50 Oracle 11g dba Interview Questions and Answers - Freshers, Experienced
Oracle 11g dba interview questions and answers for both freshers and experienced - DBMS Introduction, ORACLE ARCHITECTURE, ORACLE Installation, Oracle Environment Variables, Managing physical structures (control files, data files, redo log files), Backup and Recovery, RMAN, Performance Tuning, Data Guard.
Post your comment

Related Content

Follow us

▲