• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 818
  • Last Modified:

Ora-01122 Error

Hi all

when we try to recover the database from control file, it is working but when it is starting the database engine showing this error :
Ora-01122: database file 1:'\d:\system01.dbf'
Ora-01206: file is not part of this database - wrong database id

please Anyone has soultuion for this ?

Regards
0
ashbraim
Asked:
ashbraim
  • 2
2 Solutions
 
ysdCommented:
ora-01122 Cause: The information in this file is inconsistent with information from the
control file. See accompanying message for reason.
Action: Make certain that the database files and control files are the correct files
for this database.

ORA-01206 file is not part of this database - wrong database id
Cause: The database ID in the file header does not match the database ID in the
control file. The file may be from a different database, or it may not be a
database file at all. If the database was rebuilt, this may be a file from before the
rebuild. Note that if you see this error when the file is supposed to be plugged
in from another database via the Transportable Tablespace feature, it means the
database ID in the file header does not match the one expected.
ORA-00900 to ORA-01499 3-49
Action: Restore a copy of the correct datafile and do recovery as needed.
0
 
ysdCommented:
ora-01122 Cause: The information in this file is inconsistent with information from the
control file. See accompanying message for reason.
Action: Make certain that the database files and control files are the correct files
for this database.

ORA-01206 file is not part of this database - wrong database id
Cause: The database ID in the file header does not match the database ID in the
control file. The file may be from a different database, or it may not be a
database file at all. If the database was rebuilt, this may be a file from before the
rebuild. Note that if you see this error when the file is supposed to be plugged
in from another database via the Transportable Tablespace feature, it means the
database ID in the file header does not match the one expected.
ORA-00900 to ORA-01499 3-49
Action: Restore a copy of the correct datafile and do recovery as needed.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now