Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / 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 |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What happens on checkpoint? : sql server DBA
who owns the operating system files created by the utl_file package?
how can you find out if a table can be redefined?
how can you record information about current session?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the different sql server versions you have worked on? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what is the use of ocr?
what do you understand by fine-grained auditing?