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 / 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
Query processing is slow(eg select query)how will u solve that
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the steps you will take to improve performance of a poor performing query?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What is fill factor? : sql server DBA
which background process invoke at the time of upgradation tell me???
How would you extract DDL of a table without using a GUI tool?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how can you record information about current session?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you find out if a table can be redefined?
internal architecture
What would you do with an "in-doubt" distributed transaction?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA