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
- 10960 Views
- I also Faced
- E-Mail Answers
Answer Posted / y. naresh kumar
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE:
| Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
What the different types of replication and why are they used? : sql server DBA
internal architecture
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the steps you will take to improve performance of a poor performing query?
How would you extract DDL of a table without using a GUI tool?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can you implement fine-grained auditing?
What are the different types of indexes available in sql server? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
