Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to recover my database in DBF? Expand / Collapse
Posted Friday, July 25, 2014 11:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 11:22 AM
Points: 1, Visits: 0
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

Post #1596331
Posted Friday, July 25, 2014 11:53 AM



Group: General Forum Members
Last Login: Today @ 8:34 AM
Points: 7,507, Visits: 17,964
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?
Post #1596340
Posted Saturday, July 26, 2014 10:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 26, 2014 10:26 AM
Points: 1, Visits: 0
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 " Filename", " Tablespace name" from
2 V$datafile D, V$tablespace T
3 where D.TS# = T.TS#;




( 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 of recovery toolbox for DBF, it’s gonna help.

Post #1596514
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse