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
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.
how can you schedule a job in database?
What would you do with an "in-doubt" distributed transaction?
What the different components in replication and what is their use? : sql server DBA
how can you initialize log miner?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What the different types of replication and why are they used? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What are the different ways you can create databases in sql server? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
Why does Oracle not permit the use of PCTUSED with indexes?
how can you process messages in order asynchronously?
Explain about your sql server dba experience? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
You create a private database link and upon
connection, fails with: ORA-2085: connects to