solution

Is there any solution for these problem..

[oracle@term2 dbs]$ . oraenv orcl
ORACLE_SID = [ora11g] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle
[oracle@term2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 24 09:02:04 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  636100608 bytes
Fixed Size                  1338392 bytes
Variable Size             411042792 bytes
Database Buffers          218103808 bytes
Redo Buffers                5615616 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'
ORA-01206: file is not part of this database - wrong database id


SQL>
walkerdbaAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
The important message here is:
ORA-01206: file is not part of this database - wrong database id

Check out:
http://ora-01206.ora-code.com/

The system datafile doesn't match the control file.
0
 
Franck PachotCommented:
Hi,

If you have a doubt, you can check the database name from:
strings /u01/app/oracle/oradata/orcl/system01.dbf | head -2

same with controlfile.

Regards,
Franck.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
walkerdbaAuthor Commented:
This is the output


[oracle@term2 dbs]$ strings /u01/app/oracle/oradata/orcl/system01.dbf | head -2
}|{z
OORCL
[oracle@term2 dbs]$
0
 
slightwv (䄆 Netminder) Commented:
That seems to point to that datafile thinking it is part of a database named ORCL.

What were you doing that caused you to get this error?

Are you practicing recovery or database renaming?
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
As slightwv stated are you recovery the database or practicing to create an standby database then you messed it up by pointed the wrong datafile to the database?
0
 
walkerdbaAuthor Commented:
yes
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.