Difference between a hot backup and a cold backup

Explain the difference between a hot backup and a 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. all files of the database are copied and no changes during the copy are made.

A hot backup is taken when the database needs to run all the time. It is an online backup. All files of the database are copied and there may be changes to the database during the copy.
How many memory layers are in the oracle shared pool?
How many memory layers are in the oracle shared pool? - Oracles shared pool consists of two layers namely, Library cache and Data dictionary cache.....
What is the cache hit ratio?
Cache hit ratio - When the cache client like a CPU, web browser etc finds a successful entry in the cache memory, it is called as a cache hit...
Concept of the DUAL table
DUAL table - On installing Oracle database, DUAL table Is present by default. It is a special table with just one row.....
Post your comment