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
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain materialized views and how they are used.
what is ora 24313?what is the procedure to exclude that error?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you enable flashback feature?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what are the performance views in an oracle rac environment?
Can you redefine a table online?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What the different topologies in which replication can be configured? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
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?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA