Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to recover my database in DBF?


How to recover my database in DBF?

Author
Message
erictoledano2014
erictoledano2014
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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

thanks...
Matt Miller (#4)
Matt Miller (#4)
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7641 Visits: 18077
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?
bigmobydick2014
bigmobydick2014
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search