id="info"

Question

Locked

How to recover my database in DBF?

By OugustChshrien ·
Tags: Windows, Software
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\oradata\new1\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...

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

That's not a problem

by BIGMobyDick2014 In reply to How to recover my databas ...

I've had similar problem.

Collapse -

I suppose that I can help you.

by BIGMobyDick2014 In reply to How to recover my databas ...

You’re lucky that I’ve found your topic here.
>> datafile 2 'D:\oracle\oradata\new1\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 of recovery toolbox for DBF, it’s gonna help.
http://www.dbf.recoverytoolbox.com/

Back to Windows Forum
3 total posts (Page 1 of 1)  

Operating Systems Forums