You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
- 3 Answers
- 10894 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh chowdary
I would create a text based backup control file,
stipulating where on disk all the data files where and then
issue the recover command with the using backup control
file clause.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
when does an alert gets signaled?
how can you implement fine-grained auditing?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is the default port no on which sql server listens? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
Explain materialized views and how they are used.
how can you find out if a table can be redefined?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what do you understand by fine-grained auditing?
what is logical system in sap basis
What is dcl? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is the importance of a recovery model? : sql server DBA
