oracle实例无法关闭01122,ORA-01122 ORA-01110 ORA-01207问题总结

1.SQL>shutdown abort 如果数据库是打开状态，强行关闭

2.$ sqlplus  /nolog

SQL> conn /as sysdba;

3. SQL> startup

ORACLE instance started.

Total System Global Area 3273641984 bytes

Fixed Size                  2257680 bytes

Variable Size            1862274288 bytes

Database Buffers         1392508928 bytes

Redo Buffers               16601088 bytes

Database mounted.

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/data/oradata/rxdb/system01.dbf'

ORA-01207: file is more recent than control file - old control file

SQL>

4.SQL> alter database backup controlfile to trace as '/home/oracle/aa';

Database altered.

5.SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

6. SQL>