Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / 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 |
Post New Answer View All Answers
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?
Why does Oracle not permit the use of PCTUSED with indexes?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the commands used in dcl? : sql server DBA
what are the types of connection load-balancing?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is grd?
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?
What are statistics, under what circumstances they go out of date, how do you update them?
What is transparent data encryption? : sql server DBA
What purpose does the model database server? : sql server DBA
how can you initialize log miner?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
who owns the operating system files created by the utl_file package?