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

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2072


What is the default port no on which sql server listens? : sql server DBA

885


What authentication modes does sql server support? : sql server DBA

940


What are the operating modes in which database mirroring runs? : sql server DBA

895


how can you enable flashback feature?

744


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1881


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2296


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

1942


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1962


How would you go about verifying the network name that the local_listener is currently using?

3006


what is the use of recording information about current session?

828


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1551


what is ora 24313?what is the procedure to exclude that error?

2361


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

821


How to start SQL Server in minimal configuration mode?

7391