You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1963


What is replication? : sql server DBA

620


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601


What are the different types of database compression introduced in sql server 2008? : sql server DBA

564


Query processing is slow(eg select query)how will u solve that

6502






what is logical system in sap basis

1129


who owns the operating system files created by the utl_file package?

562


what are the differences of where and if in SAS?

1662


How would you best determine why your MVIEW couldn't FAST REFRESH?

1826


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

558


How do you troubleshoot errors in a sql server agent job? : sql server DBA

561


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

704


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1541


how can you communicate with operating system files from oracle?

556


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

589