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
What is a correlated sub-query? : sql server DBA
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?
How do you trace the traffic hitting a sql server? : sql server DBA
how to restore files with rman?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what are the differences of where and if in SAS?
what is asm?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA