Yesterday, the company's database has problems. Due to the power failure (Oracle is in the open state), the database starts the wrong ORA-00214: ControlFile 'D: /oracle/oradata/orcl/control01.ctl' version 57460 InconsiStent with file d: / oracle / OraData/orcl/control02.ctl 'Version 57452. ORA-01122 Atabase File1 Failed Verfication Check This is due to control file versions. During the database design, from a secure point of view, the system uses three mirrored control files, and now the three control file Version numbers are inconsistent, so the database instance is started. I first backed up the control file, launched the database to the Nomount state, specify one of the ALTER SESTEM SET Control_Files = 'f: /oracle/oradata/oracas/control01.ctl' scope = SPFILE, respectively, the system control file is three. Start the database to the mount state, if you still report an error, specify the next alter system set control_files = 'f: /oracle/oradata/oracas/control02.ctl' scope = spfile then start the database to the mount state, if it is still an error, Specify the next alter system set control_files = 'f: /oracle/oradata/racas/control03.ctl' scope = SPFile As long as it is successful in the above three operations, you can use that successful control file to re-make two other control files. .
