ORA-01190: control fil…

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

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified forRDBMS 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 lastRESETLOGS

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

Oracle社区，君子所见略同：

看来只能重建控制文件了

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

 BPeaslandDBA

Titan

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

The error is saying that at some point in time, you performedan OPEN RESETLOGS option. The control file you are currently usingis 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 othercopies are more recent. If so, then you can simply copy one of themto 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 CREATECONTROLFILE command. And you may have to apply incompleterecovery.

 

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

 

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

 

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

 

HTH,

Brian

SQL> @TEST3_Con.sql

CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS FORCELOGGING ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01100: database already mounted

SQL> shutdown

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup nomount;

ORA-32004: obsolete or deprecated parameter(s) specified forRDBMS 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

SQL>  @TEST3_Con.sql

Control file created.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option fordatabase open

SQL> alter database open RESETLOGS;

Database altered.

SQL>  desc scott.test0814

 Name                                Null?   Type

 ------------------------------------------------- ----------------------------

 ID                                         NUMBER

SQL>