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.

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.

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.

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

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"

Answer / guest

Manoj,

Who told you, hot backup is logical.

Answer / manoj

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.

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

What is a system database and what is a user database? : sql server DBA

0 Answers  

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

Name three advisory statistics you can collect.

1 Answers  

How to determine the service pack currently installed on SQL Server?

1 Answers  

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

7. Where should you place Archive logfiles, in the same disk where DB is or another disk? 8. Can you take online backup of a Control file if yes, how? 9. What is a Logical Backup? 10. Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode? 11. Why do you take tablespaces in Backup mode? 12. What is the advantage of RMAN utility? 13. How RMAN improves backup time? 14. Can you take Offline backups using RMAN? 15. How do you see information about backups in RMAN? 21. Where RMAN keeps information of backups if you are using RMAN without Catalog? 22. You have taken a manual backup of a datafile using o/s. How RMAN will know about it? 23. You want to retain only last 3 backups of datafiles. How do you go for it in RMAN? 24. Which is more efficient Incremental Backups using RMAN or Incremental Export? 25. Can you start and shutdown DB using RMAN? 26. How do you recover from the loss of datafile if the DB is running in NOARCHIVELOG mode? 27. You loss one datafile and it does not contain important objects. The important objects are there in other datafiles which are intact. How do you proceed in this situation? 28. You lost some datafiles and you don't have any full backup and the database was running in NOARCHIVELOG mode. What you can do now? 29. How do you recover from the loss of datafile if the DB is running in ARCHIVELOG mode? 30. You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file? 31. You loss controlfile how do you recover from this? 32. The current logfile gets damaged. What you can do now? 33. What is a Complete Recovery? 34. What is Cancel Based, Time based and Change Based Recovery? 35. Some user has accidentally dropped one table and you realize this after two days. Can you recover this table if the DB is running in ARCHIVELOG mode? 36. Do you have to restore Datafiles manually from backups if you are doing recovery using RMAN? 37. A database is running in ARCHIVELOG mode since last one month. A datafile is added to the database last week. Many objects are created in this datafile. After one week this datafile gets damaged before you can take any backup. Now can you recover this datafile when you don't have any backups? 38. How do you recover from the loss of a controlfile if you have backup of controlfile? 39. Only some blocks are damaged in a datafile. Can you just recover these blocks if you are using RMAN? 40. Some datafiles were there on a secondary disk and that disk has become damaged and it will take some days to get a new disk. How will you recover from this situation? 41. Have you faced any emergency situation. Tell us how you resolved it? 42. At one time you lost parameter file accidentally and you don't have any backup. How you will recreate a new parameter file with the parameters set to previous values. 16. What is a Recovery Catalog? 17. Should you place Recovery Catalog in the Same DB? 18. Can you use RMAN without Recovery catalog? 19. Can you take Image Backups using RMAN? 20. Can you use Backupsets created by RMAN with any other utility?

1 Answers   IBM,

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

what is difference between user managed backup and rman backup?

1 Answers   CTS,

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,