Link to home
Create AccountLog in
Avatar of walkerdba
walkerdba

asked on

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>
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
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.
ASKER CERTIFIED SOLUTION
Avatar of YZlat
YZlat
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of walkerdba

ASKER

This is the output


[oracle@term2 dbs]$ strings /u01/app/oracle/oradata/orcl/system01.dbf | head -2
}|{z
OORCL
[oracle@term2 dbs]$
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?
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?
yes