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


Please Help Members By Posting Answers For Below Questions

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1705


how can you schedule a job in database?

603


What would you do with an "in-doubt" distributed transaction?

1421


What the different components in replication and what is their use? : sql server DBA

542


how can you initialize log miner?

583






i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1643


What the different types of replication and why are they used? : sql server DBA

571


What are the steps you will take to improve performance of a poor performing query?

2423


What are the different ways you can create databases in sql server? : sql server DBA

601


How would you best determine why your MVIEW couldn't FAST REFRESH?

1837


Why does Oracle not permit the use of PCTUSED with indexes?

2334


how can you process messages in order asynchronously?

557


Explain about your sql server dba experience? : sql server DBA

551


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2112


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1545