You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / y. naresh kumar
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE:
Is This Answer Correct ? | 12 Yes | 6 No |
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is RAID and what are different types of RAID configurations?
what is logical system in sap basis
how do see how much space is used and free in a tablespace
What the different types of replication and why are they used? : sql server DBA
Where in the Oracle directory tree structure are audit traces placed?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is incremental checkpoint?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you implement fine-grained auditing?
How do you open a cluster administrator? : sql server DBA