Interested to Buy Any Domain ? << Click Here >> for more details...
deleted of control file how will u recover control file?
- 4 Answers
- 9107 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
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the different types of indexes available in sql server? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
how can you record information about current session?
What is a system database and what is a user database? : sql server DBA
What is a correlated sub-query? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you process messages in order asynchronously?
What are the recovery models for a database? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What purpose does the model database server? : sql server DBA
What authentication modes does sql server support? : sql server DBA
What happens on checkpoint? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
