deleted of control file how will u recover control file?
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 do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Why would you call update statistics? : sql server DBA
What are the commands used in dcl? : 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
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are statistics, under what circumstances they go out of date, how do you update them?
what functionality does oracle provide to secure sensitive information?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is a correlated sub-query? : sql server DBA
What is transparent data encryption? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Where would you look for errors from the database engine?
What are the operating modes in which database mirroring runs? : sql server DBA