ORA-01189: file is from a different RESETLOGS than previous
files
- 1 Answers
- 5027 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: In a CREATE CONTROLFILE command either this file or
all previous files were backups from before the last
RESETLOGS. This may also 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 normal 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
resubmit the command.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
NCR-04010: NCRR: Unable to contact Oracle Names Server
ORA-12819: missing options in PARALLEL clause
ORA-31430: subscriber view exists
DRG-12505: error while adding or removing a stop word
NCR-01005: NCRS: Failed to flush the output buffer.
PCC-02023: Found end of file while scanning a PL/SQL statement
ORA-01332: internal Logminer Dictionary error
ORA-38471: ROWIDs for table aliases cannot be null
ORA-07393: unable to delete text file
ORA-02804: Allocation of memory failed for log file name
ORA-09815: File name buffer overflow
ORA-23357: the propagator does not exist
Oracle Errors 
