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

how can you connect from 10g user to 11g user??

1681


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

729


Where do you find the default index fill factor and how to change it? : sql server DBA

554


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

1826


Why does Oracle not permit the use of PCTUSED with indexes?

2327






What is dcl? : sql server DBA

646


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

558


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1520


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1867


how can you schedule a job in database?

595


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1653


What is the difference between dropping a database and taking a database offline? : sql server DBA

576


What is dbcc? : sql server DBA

777


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1233


How do you trace the traffic hitting a sql server? : sql server DBA

843