Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
- 7 Answers
- 21668 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep
Cold Backup - In this case, they take the database down
then they have backup. this is called cold backup.
Hot Backup - In this case, they take running database
backup (like SQL Server) this is called hot backup.
| Is This Answer Correct ? | 29 Yes | 1 No |
Answer / vaishnav
when the database is closed then this backup is called cold
backup. while, when the database is running/opened then
this backup is called hot backup.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / shabbeer.ahmad
A hot backup is basically taking a backup of the database
while it is still up and running and it must be in archive
log mode. A cold backup is taking a backup of the database
while it is shut down and does not require being in archive
log mode. The benefit of taking a hot backup is that the
database is still available for use while the backup is
occurring and you can recover the database to any point in
time. The benefit of taking a cold backup is that it is
typically easier to administer the backup and recovery
process. In addition, since you are taking cold backups the
database does not require being in archive log mode and thus
there will be a slight performance gain as the database is
not cutting archive logs to disk.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / balakrishna
hot backup mean as we can take backup when the database is
up and running
cold backup we need to shut down the database
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / kittu
using hot backup u can backup controlfile @ oracle lever by issuing the "alter database backup controlfile to trace;" or "alter database backup controlfile to '/userdefined_path/control_backup.ctl"
| Is This Answer Correct ? | 2 Yes | 1 No |
Hot Backup: Its logical backup of database. It is done while
the database is running. One can backup Entire database or
Users or Tables optinally in this type.
Cold Backup: Its physical backup of the database. It requres
database to be shutdown. Files are physically copied to some
other location as backup.
| Is This Answer Correct ? | 9 Yes | 26 No |
what is ora 24313?what is the procedure to exclude that error?
how does an oracle clusterware manage crs resources?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How would you extract DDL of a table without using a GUI tool?
What are the ways tablespaces can be managed and how do they differ?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
What are the operating modes in which database mirroring runs? : sql server DBA
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
any body know about orawaves do they really provide placements in their unique placement program
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
