How do you recover a lost control file?
Answer / Manoj Singh
To recover a lost control file in Oracle, you can restore it from a backup or create a new one using the CREATE CONTROLFILE command. If no backup exists, you may need to use media recovery or contact Oracle Support.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is split brain syndrome in rac?
How would you differentiate between cluster and grid?
Why do we need to rebuild indexes?
What is an explain plan and how does it help in optimizing the sql query?
What is olr?
What is tkprof and how can we use it?
How can we identify the resources for which the sessions are waiting?
Mention what are the tools provided in oracle enterprise manager?
How can a single instance environment be converted into rac environment and how will they be different?
What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?
What are the benefits of oracle real application clusters (rac)?
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?