Shulou(Shulou.com)06/01 Report--

ORA-01189: the file comes from a different RESETLOGS than the previous file

ORA-01110: data file 4: d:\ ORCLDATA\ XEPACS\ USERS01.DBF'

ORA-01189 explained:

Cause: In a CREATE CONTROLFILE command, either this file or all previous files were backups from before the last RESETLOGS. This also may occur if this is a file that is offline and has been offline since before the last RESETLOGS.

Action: If the file was taken offline normally before the last RESETLOGS and is still offline, omit it from the CREATE CONTROLFILE command. Rename and online the file after the database is open. Otherwise, find the version of the mentioned file consistent with the rest of the datafiles and retry the command.

1 skip the problematic data file to rebuild the control file or use system01.dbf only to rebuild

2 resetlogs open the database, pay attention to change the parameter related to undo to manual

Alter system set "_ allow_resetlogs_corruption" = true scope=spfile alter system set audit_trail=none scope=spfile; alter system set undo_management=MANUAL scope=spfile

3 datafile with problems with rename after startup

Alter database rename file'd:\ ORACLE\ PRODUCT\ 10.2.0\ DBHOME_1\ DATABASE\ MISSING00004' to'd:\ orcldata\ xepacs\ users01.dbf'

Due to the low scn, you need to adjust the resetlogs to be consistent, or use bbed to adjust it.

# 4 promote scn

ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME ADJUST_SCN LEVEL 1'

LEVEL: Level 1 is usually sufficient-it raises the SCN to 1 billion

5 alter database datafile 4 online

Startup mount

SQL > recover until cancel

Complete the media recovery.

SQL > alter database datafile 4 online

The database has changed.

6 SQL > alter database open resetlogs

This scenario applies to data files that have been in offline for a long time, then online, lost archives, or unexpected database downtime.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.