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
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What are the operating modes in which database mirroring runs? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What is the default fill factor value? : sql server DBA
what are the types of connection load-balancing?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the different ways you can create databases in sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How to start SQL Server in minimal configuration mode?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is the default port no on which sql server listens? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?