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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Can you redefine a table online?
how can you get actual data change values from previous transactions in oracle?
What are the different sql server versions you have worked on? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you process messages in order asynchronously?
List out some of the requirements to setup a sql server failover cluster.? : 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 happens on checkpoint? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What is the default fill factor value? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?