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
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what are the benefits of flashback feature?
what are the types of connection load-balancing?
What are the different sql server versions you have worked on? : sql server DBA
how can you implement fine-grained auditing?
How can you control the amount of free space in your index pages? : sql server DBA
What is replication? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the different ways you can create databases in sql server? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What is a system database and what is a user database? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.