1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?

Question Posted / guest

Answers were Sorted based on User's Feedback



You have just had to restore from backup and do not have any control files. How would you go about ..

Answer / anonymous

Have to manually create a new control file.

Is This Answer Correct ?    8 Yes 0 No

You have just had to restore from backup and do not have any control files. How would you go about ..

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

You have just had to restore from backup and do not have any control files. How would you go about ..

Answer / y. naresh kumar

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE:

Is This Answer Correct ?    12 Yes 6 No

Post New Answer

More DB Administration Interview Questions

What is dcl? : sql server DBA

0 Answers  

How would you go about generating an EXPLAIN plan?

2 Answers  

what is the use of ocr?

0 Answers   Oracle,

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

What is a correlated sub-query? : sql server DBA

0 Answers  




what is the difference between catalog & nocatalog?

3 Answers   CSC,

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

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

0 Answers  

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories