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
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
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.
what are the performance views in an oracle rac environment?
What are statistics, under what circumstances they go out of date, how do you update them?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how does an oracle clusterware manage crs resources?
Why would you use sql agent? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what do you understand by fine-grained auditing?
What is fill factor? : sql server DBA