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

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

3 Answers
11618 Views
I also Faced
E-Mail Answers

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 the importance of a recovery model? : sql server DBA

0 Answers

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers

From the database level, how can you tell under which time zone a database is operating?

1 Answers

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

4 Answers

What are the recovery models for a database? : sql server DBA

0 Answers

how can you schedule a job in database?

0 Answers Oracle,

How do you switch from an init.ora file to a spfile?

4 Answers TCS,

What is the default fill factor value? : sql server DBA

0 Answers

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers

For more DB Administration Interview Questions Click Here