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

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers

What are the ways tablespaces can be managed and how do they differ?

2 Answers IBM,

Where would you look for errors from the database engine?

0 Answers IBM,

how can you communicate with operating system files from oracle?

0 Answers Oracle,

How do you troubleshoot errors in a sql server agent job? : 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 authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers

how can you find out if a table can be redefined?

0 Answers Oracle,

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

How can you rebuild an index?

6 Answers

For more DB Administration Interview Questions Click Here