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.