What is the difference between cold backup and hot backup?
- 1 Answers
- 666 Views
- I also Faced
- E-Mail Answers
Answer / Chandra Kant Pandey
The main difference between a cold backup and a hot backup in Oracle is that a cold backup requires the database to be shut down, while a hot backup allows the database to remain online. This has implications for data consistency and downtime:
1. Cold Backup: Provides a consistent snapshot of the database, but requires significant downtime to perform.
2. Hot Backup: Allows for minimal downtime (e.g., during RMAN backup with no datafile copies), but the restored database may contain transactionally inconsistent data.
| Is This Answer Correct ? | 0 Yes | 0 No |
What causes the "snapshot too old" error? How can this be prevented or mitigated?
Tell me about standby database? What should we watch out for?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
What are some indications that you need to increase the shared_pool_size parameter?
How many databases should a dba manage?
When should an artificial (or derived) primary key be used?
What are roles in oracle?
System tablespace cant be exported from one database and imported into another why?
I am getting error "no communication channel" after changing the domain name? What is the solution?
Discuss row chaining, how does it happen? How do you correct it?
How do you prevent output from coming to the screen?
What is the difference between truncate and delete? How would a full table scan behave after?
Oracle General 
