Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / 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"
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different sql server versions you have worked on? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What happens on checkpoint? : sql server DBA
what is asm?
how can you initialize log miner?
what is grd?
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?
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?
How would you extract DDL of a table without using a GUI tool?
What are statistics, under what circumstances they go out of date, how do you update them?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what are the types of connection load-balancing?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What the different types of replication and why are they used? : sql server DBA
how to restore files with rman?