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 / y. naresh kumar
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE:
| Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
What is the default fill factor value? : sql server DBA
What the different topologies in which replication can be configured? : 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?
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.
What is replication? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the different ways you can create databases in sql server? : sql server DBA
How do you open a cluster administrator? : sql server DBA
internal architecture
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 are the differences of where and if in SAS?
What is dbcc? : sql server DBA
how can you schedule a job in database?
What happens on checkpoint? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA