ORA-01190: control fil…-CSDN博客

本文链接：https://blog.csdn.net/babymouse1212/article/details/71079133

open resetlogs后使用旧的备份的控制文件恢复控制文件，打开报错

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 5346328576 bytes

Fixed Size 2168728 bytes

Variable Size 2264926312 bytes

Database Buffers 3053453312 bytes

Redo Buffers 25780224 bytes

Database mounted.

ORA-01190: control file or data file 1 is from before the last RESETLOGS

ORA-01110: data file 1: '/share/oradata2/d1.dbf'

Oracle社区，君子所见略同：

看来只能重建控制文件了

3. Re: control file or data file 1 is from before the last RESETLOGS

BPeaslandDBA

Titan

BPeaslandDBA 2015-1-20 上午9:36 （回复 user13389359）

The error is saying that at some point in time, you performed an OPEN RESETLOGS option. The control file you are currently using is from prior to that time and the datafiles are after that time. You need a more current control file.

If you multiplex your control files, check to see if the other copies are more recent. If so, then you can simply copy one of them to replace this one.

If all else fails, you can manually create the controlfiles. This part of the docs describes the process: http://docs.oracle.com/cd/B28359_01/server.111/b28310/control003.htm#ADMIN11289

You will need to supply all of the info to the CREATE CONTROLFILE command. And you may have to apply incomplete recovery.

I make it a best practice to take a backup after the OPEN RESETLOGS command is issued. This way, I don't have to worry about situations just like this.

Also, before you go and create a new control file if that is the way you want to recover from this error, I highly recommend that you back up everything before you begin. That way, if something goes wrong, you can always get back to this point in time and try again.

Once you have everything back up and running, make sure you get a good backup of the entire database.

HTH,

Brian