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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what do you understand by fine-grained auditing?

644


how can a session indicate its interest in receiving alerts?

574


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

623


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

558


What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

561






What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1981


how can you get actual data change values from previous transactions in oracle?

625


what is the use of ocr?

608


when does an alert gets signaled?

590


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.

1709


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

2429


who owns the operating system files created by the utl_file package?

574


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1505


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?

1663


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1882