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 rebuild index??

2 Answers   IBM, Sapient,

What is the importance of a recovery model? : sql server DBA

0 Answers  

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

what is meant by gateway

1 Answers   IBM,

How to determine the service pack currently installed on SQL Server?

1 Answers  

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

Name three advisory statistics you can collect.

1 Answers  

Name two files used for network connection to a database.

5 Answers  

how can you record information about current session?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories