Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

How would you determine the time zone under which a database was operating?

2 Answers  

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

How would you determine who has added a row to a table?

4 Answers  

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

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

0 Answers  

what is the purpose of catlaog in oracle rman?

2 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  

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

0 Answers  

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

0 Answers  

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories