ORA-01122 ORA-01110 ORA-01207 error for Oracle Database

Retain the data files, control files, and redo log files of the original database on Windows.

Reinstall the Windows system and redo the database.

1. Install Oracle database software

2. Use Oracle dbca to create a database with the same name as the original database

3. Back up the spfile file (usually in the $ ORACLE_HOME \ dbs directory) and generate a pfile (usually in the $ ORACLE_HOME \ database directory ):

SQL> create pfile from spfile;

4. Modify the path of the pfile control file. Path pointing to the control file of the original reserved Database

5. Start the database

SQL> startup

If the database is started to the mount State and cannot be started to the open state, the following error is usually reported:

ORA-01122: database file 1 Verification Failed

ORA-01110: Data File 1: 'e: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ XBOMS \ system01.dbf'

ORA-01207: file ratio control file update-old control file

Solution:

Recreate the control file:

1. SQL> alter database backup controlfile to trace as 'e: \ trace ';

2. Shut down the database: shutdown immediate

3. Start: startup nomount

4. Open the 'e: \ trace 'file, run the following statement on the database command line, and recreate the control file.

Create controlfile reuse database "XBOMS" NORESETLOGS NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

# MAXLOGHISTORY 292

LOGFILE

GROUP 1 'e: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ XBOMS \ redo01.log' SIZE50M,

GROUP 2 'e: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ XBOMS \ REDO02.LOG 'SIZE50M,

GROUP 3 'e: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ XBOMS \ REDO03.LOG 'SIZE50M

DATAFILE

'E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ XBOMS \ system01.dbf ',

'E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ XBOMS \ undotbs01.dbf ',

'E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ XBOMS \ sysaux01.dbf ',

'E: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ XBOMS \ users01.dbf ',

Character set ZHS16GBK

;

5. RECOVER DATABASE

6. alter database open;