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 is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

How can you enable a trace for a session?

1 Answers  

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

Can you redefine a table online?

0 Answers   Oracle,

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

What is RAID and what are different types of RAID configurations?

1 Answers  

how can you enable flashback feature?

0 Answers   Oracle,

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers