Your error indicates that your file has become shorter by 1540 bytes than the size listed in your control file. Such a thing happens as a result of files getting corrupted for some reason. You will need to replace this file with another from your backup [I hope you were backing up your database] and then apply recover command to recover it. This scenario is for databases under archive log mode. If your database was not being archived or if you were taking only cold backups then you may want to return back to your last cold backup copy. In this scenario you may lose work since last cold backup. If you were not taking any backups at all, I will suggest you to check with your sysadmin if operating system level backups were being taken of the server machine. If yes, you could startup a database by getting those files [may be - not positive - you will need to create a control file and opem database in resetlogs mode]. There are quite a few scenarios to consider before arriving at an exact solution for you.
Gurmohan
www.freemath.com
-----Original Message-----
From: anirban
[mailto:oracledba-ezmlmshield-x96529977.[Email address protected]
Sent: Wednesday, July 06, 2005 8:26 AM
To: LazyDBA Discussion
Subject: ORA:01200
Hi
Pls help me to close the problem described below
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jul 6 16:40:57 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1259833760 bytes
Fixed Size 731552 bytes
Variable Size 838860800 bytes
Database Buffers 419430400 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6:
'/database/oracle9i2/app/oracle/product/9.2.0/oradata/ctmis/users01.dbf'
ORA-01200: actual file size of 176160 is smaller than correct size of 177600
blocks
SQL> SQL>
Regds
Anirban
Confidentiality Notice
The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page