The original controlfile is available below:
The procedure is as follows:
Startup force;
Alter system set "_ allow_resetlogs_upload uption" = true scope = spfile;
Recover database using backup controlfile until cancel;
Alter databse open resetlogs;
SQL> startup force;
The Oracle routine has been started.
Total System Global Area 603979776 bytes
Fixed Size 1250380 bytes
Variable Size 222301108 bytes
Database Buffers 373293056 bytes
Redo Buffers 7135232 bytes
The database has been loaded.
ORA-01190: control file or data file 1 comes before the last RESETLOGS
ORA-01110: Data File 1: 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ SHENG \ SYSTEM01.DBF'
SQL> alter system set "_ allow_resetlogs_uption" = true scope = spfile;
The system has been changed.
SQL> recover database using backup controlfile until cancel;
ORA-00279: Change 563772 (generated at 17:13:09) is required for thread 1
ORA-00289: Recommended: D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ARCH \ 001_1771181989.arc
ORA-00280: Change 563772 (for thread 1) in sequence #1
Specified log: {<RET> = suggested | filename | AUTO | CANCEL}
Cancel
Media recovery has been canceled.
D: \ oracle \ product \ 10.2.0 \ db_1 \ RDBMS \ lib> sqlplus/as sysdba
SQL * Plus: Release 10.2.0.1.0-Production on Thursday December 29 19:50:18 2011
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
SQL> select status from v $ intance;
Select status from v $ intance
*
Row 3 has an error:
ORA-01219: Database not open: Allow queries only in fixed tables/Views
SQL> select status from v $ instance;
STATUS
------------
MOUNTED
SQL> alter database open resetlogs;
The database has been changed.
SQL>
SQL> select status from v $ instance;
STATUS
------------
OPEN
Note: Remove "_ allow_resetlogs_upload uption" = true after opening.