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

how does an oracle clusterware manage crs resources?

0 Answers Oracle,

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers

why do we give pctfree and pctused in create table statement?

1 Answers CTS,

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers TCS,

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 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?

1 Answers

Explain the concept of the DUAL table.

3 Answers

how can you get actual data change values from previous transactions in oracle?

0 Answers Oracle,

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers

how can you create a user-defined lock?

0 Answers Oracle,

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

For more DB Administration Interview Questions Click Here