What are the steps involved in instance recovery in oracle?
- 1 Answers
- 638 Views
- I also Faced
- E-Mail Answers
Answer / Mohd Nazim
The steps for Oracle instance recovery include starting the database in mount mode, opening the control files and determining if a recovery is needed, starting the database in recovery mode, performing media recovery (if required), switching to nomount mode to check the integrity of datafiles, and finally starting the database in normal mode.
| Is This Answer Correct ? | 0 Yes | 0 No |
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
What does a senior database administrator do?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What does the no logging option do? Why would we be careful of using it?
What is the purpose of the import option ignore? What is its default setting?
What is your favorite tool for day-to-day oracle operation?
What is tkprof and how is it used?
What do you understand by the term 'normalization'?
What is the easiest method to create a file on unix?
What do you mean by dba?
If you have an example table, what is the best way to get sizing data for the production table implementation?
Oracle General 
