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
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is dbcc? : sql server DBA
how can you process messages in order asynchronously?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What are the recovery models for a database? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is replication? : sql server DBA
what are the performance views in an oracle rac environment?
What is transparent data encryption? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?