You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
Answer Posted / anonymous
Have to manually create a new control file.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the default fill factor value? : sql server DBA
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.
What is a system database and what is a user database? : sql server DBA
what is a user-defined lock?
What the different topologies in which replication can be configured? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how to restore files with rman?
how can a session indicate its interest in receiving alerts?
What are the different types of indexes available in sql server? : sql server DBA
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
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to