Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

If Control File is Corrupted then What will happen to Database?

Updated May 19, 2018

Hello Experts,

If two control files are there for one database, one user already connected to the database, he will do some transactions on database,unfortunately one control file was corrupted. what will happen?

1 ) Is there any effect on current transaction?
2 ) Is there any effect on user connection ?
3 ) We are get any message on alert log?
4 ) What happen on current instance?

Kindly share your valuable views here, thanks in advance.

Comments

07 Oct 2015 12:19 pm Sushma Helpful Answer

Immediately instance will be terminated. you should create one more control file using multiplex controlfile and after start an instance.

08 Oct 2015 9:14 am Dazy Parker

Control file keeps records of the physical structure of the database. When it corrupt then the instance will be terminated. You can also create control files later, if you lose control files or want to change particular settings in the control files.