Interested to Buy Any Domain ? << Click Here >> for more details...
deleted of control file how will u recover control file?
- 4 Answers
- 8701 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / suman
we are restore the control file from cold/hot backup
after that
$sqlplus / 'as sysdba'
>startup nomount
>recover database using backup controlfile until cancel;
>alter database mount;
>alter database open resetlogs;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How do you trace the traffic hitting a sql server? : sql server DBA
What purpose does the model database server? : sql server DBA
internal architecture
What types of replication are supported in sql server? : sql server DBA
Why would you use sql agent? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What would you do with an "in-doubt" distributed transaction?
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.
What is the difference between dropping a database and taking a database offline? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
Explain materialized views and how they are used.
Where would you look for errors from the database engine?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What is the difference between clustered and non-clustered index? : sql server DBA
