ORA-01122, ORA-01110, ORA-01200 2004-02-18 - By Reidy, Ron
>From oerr:
$ oerr ora 1122
01122, 00000, "database file %s failed verification check"
// *Cause: The information in this file is inconsistent with information
// from the controlfile. See accompanying message for reason.
// *Action: Make certain that the db files and controlfiles are the correct
// files for this database.
Looks like you may have some issues (i.e. copying datafiles and control files
when the database was running, etc.).
If this is not the case, you will (most likely) need to open a TAR with Oracle
support.
-- ---- ---- ----
Ron Reidy
Senior DBA
Array BioPharma, Inc.
-- --Original Message-- --
From: Kuru Murat [mailto:Murat.Kuru@(protected)]
Sent: Wednesday, February 18, 2004 12:40 AM
To: suse-oracle@(protected)
Subject: RE: [suse-oracle] ORA-01122 (See ORA-01122.ora-code.com), ORA-01110 (See ORA-01110.ora-code.com), ORA-01200 (See ORA-01200.ora-code.com)
Can't anybody help me with the issue below?
-- --Original Message-- --
From: Kuru Murat
Sent: Dienstag, 17. Februar 2004 11:26
To: suse-oracle@(protected)
Subject: [suse-oracle] ORA-01122 (See ORA-01122.ora-code.com), ORA-01110 (See ORA-01110.ora-code.com), ORA-01200 (See ORA-01200.ora-code.com)
Hi Folks,
I get the erros below.
ERROR at line 1:
ORA-01122 (See ORA-01122.ora-code.com): database file 1 failed verification check
ORA-01110 (See ORA-01110.ora-code.com): data file 1:
'/opt/oracle/OraHome1/dbs/testb/data/system01.dbf'
ORA-01200 (See ORA-01200.ora-code.com): actual file size of 57410 is smaller than correct size of
83200 blocks
This is only a test database and the data in it isn't important.
Is would like to open the database, but while trying, I get the errors
above.
I can't recover the original system01.dbf file.
Any idea on how I can open the database?
Cheers,
Murat Kuru
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____
Comfone Ltd.
mailto:sysadmin@(protected)
Murat Kuru Tel: +41 31 341 1414
Systems Analyst Fax: +41 31 341 1455
a TOGEWA group company visit our homepage: www.comfone.com
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
