deleted of control file how will u recover control file?
Answer Posted / raj
If RMAN backup exists
go to RMAN prompt
recover controlfile from backup controlfile
restore database from bckup
recover database
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how can you find out if a table can be redefined?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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
Explain materialized views and how they are used.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what functionality does oracle provide to secure sensitive information?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
Can you redefine a table online?
What are the different types of indexes available in sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is asm?
What authentication modes does sql server support? : sql server DBA
What happens on checkpoint? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?