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
how can you process messages in order asynchronously?
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
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is the use of recording information about current session?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
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 is the default fill factor value? : sql server DBA
what are the differences of where and if in SAS?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to start SQL Server in minimal configuration mode?
how can you get actual data change values from previous transactions in oracle?
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.
How do you open a cluster administrator? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com