宏发地产集团控制文件OLD错误.docxVIP

由于强制关机或者是停电导致的控制文件错误恢复方法 startup启动报错 ORA-01122 database file 1 failed verification check ORA-01110 data file 1 u01TS1datasystem.280.948328549 ORA-01207 file is more recent than control file - old control file 实际方法如下： 方法1： u 主导思想：创建控制文件，然后open数据库。 u 具体步骤： 1.startup mount 2.alter database backup controlfile to trace 3.create a control file creation script from the trace file, and use the noresetlogs option 4.shutdown 5.startup nomount Use the script generated by the backup controlfile to trace command above creaet the control file 6.recover database 7.alter database open u 步骤演示： [oracle@localhost orcl]$ sqlplus as sysdba SQLPlus Release 10.2.0.1.0 - Production on Sun Nov 19 152607 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options 添加测试数据： SQL create table gaojf as select from all_objects; Table created. SQL insert into gaojf select from gaojf; 49390 rows created. SQL 98780 rows created. ………………………………… 1580480 rows created. SQL commit; Commit complete. SQL shutdown abort ORACLE instance shut down. SQL quit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -Production With the Partitioning, OLAP and Data Mining options 模拟ORA-01207错误很简单，这里不再说明，然后接着如下： [oracle@localhost orcl]$ sqlplus as sysdba SQLPlus Release 10.2.0.1.0 - Production on Sun Nov 19 152647 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL startup ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size bytes Database Buffers ytes Redo Buffers 2973696 bytes Database mounted. ORA-01122 database file 1 failed verification check ORA-01110 data file 1 freeoracleoradataorclsystem01.dbf ORA-01207 file is more recent than control file - old control file 出现了OR