July 25, 2014 at 11:23 am
hi everybody,
i'm getting the following error on starting oracle database throught the enterprise manager console :
ORA-01122 : database file 2 failed verification check
ORA-01110 : datafile 2 'D:\oracle\oradataew1\undotbs01.dbf'
ORA-01200 : actual file size of 72733 is smaller than correct size of 72960 blocks.
the database mounts but is not able to open..(i don't have any backup of the databse nor the datafiles)
plz help
thanks...
July 25, 2014 at 11:53 am
Eric -
You might get lucky here (some folks deal with both Oracle and SQL Server), but If you need Oracle help, you probably want to ask on an Oracle site. It actually sounds like you need DBASE or FoxPro help, given the DBF extension (both have been out of support for several years so that in itself might be a problem).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
July 26, 2014 at 10:27 am
You’re lucky that I’ve found your topic here. I suppose that I can help you.
>> datafile 2 'D:\oracle\oradataew1\undotbs01.dbf'
As the name of the datafile suggest, it's a datafile attached to undo tablespace and if it is so then only one concern is there --
whether last time ur database was shutdown properly or not.
First of all at mount stage check the datafile belongs to undo tablespace or not. Use this query from sqlplus at mount stage --
SQL> select D.name " Filename", T.name " Tablespace name" from
2 V$datafile D, V$tablespace T
3 where D.TS# = T.TS#;
FILE_NAME
------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
D:\ORACLE\ORADATA\TANUDB1\SYSTEM01.DBF
SYSTEM
D:\ORACLE\ORADATA\TANUDB1\UNDOTBS01.DBF
UNDOTBS1
D:\ORACLE\ORADATA\TANUDB1\DRSYS01.DBF
DRSYS
( on my machine)
As it shows that UNDOTBS01.DBF belongs to undotbs1 ( undo tablespace ) , if it is so on ur machine then do this :
--Take the specific datafile offline
SQL> alter database datafile 'D:\ORACLE\ORADATA\TANUDB1\UNDOTBS01.DBF' offline drop;
Database altered.
-- Open the database
SQL> alter database open;
Database altered.
-- create a new undo tablespace (like this)
SQL> create undo tablespace undotbs2
2 datafile 'D:\ORACLE\ORADATA\TANUDB1\UNDOTBS02.dbf' size 100M;
Tablespace created.
SQL> alter system set undo_tablespace=undotbs2;
System altered.
and u can use ur system freely, nothing is lost.
A word of caution ---
This scenario is going to work provided
-- That datafile belongs to undo tablespace.
But if it doesn’t help try free demo[/url] of recovery toolbox for DBF, it’s gonna help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply