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 the different topologies in which replication can be configured? : sql server DBA
What is fill factor? : sql server DBA
what is a user-defined lock?
who owns the operating system files created by the utl_file package?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
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 the 2 operating modes of database mirroring? : sql server DBA
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
What happens on checkpoint? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How would you best determine why your MVIEW couldn't FAST REFRESH?
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.
what is the use of recording information about current session?
What are the different sql server versions you have worked on? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA