Home » RDBMS Server » Backup & Recovery » ora-01110: data file 10 (oracle 10.2.0 on sloaris 10)
ora-01110: data file 10 [message #423785] Mon, 28 September 2009 04:08 Go to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
hi,

i have deleted datafile and now i am trying to recover
i don't have physical backup but do have user lvl export but i can't open my dtabase as i recevie the following error


ora-01110: data file 10
'/u01/app/oracle/oracle/product/10/2/0/db-1/oradata/user01.dbf'
ora-01115:IO error reading block from file 10(block#1)
ora-27069: attempt to do I/O beyond the range of the file
additional information :1
additional information :1

so i can't import


please anyone can help me to pen my db or how can i recover

regards

janakors
Re: ora-01110: data file 10 [message #423786 is a reply to message #423785] Mon, 28 September 2009 04:15 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

You cann't use logical backup of database to recover the datafile. You need to have full backup of datafile or database and archived redo log files

BTW, why you don't have any backup of your database??
Re: ora-01110: data file 10 [message #423790 is a reply to message #423785] Mon, 28 September 2009 04:57 Go to previous messageGo to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
thanks for response

it is a test database so i am doing exercise on it and i have following solutions

1.take that tablespace offline to whom that lost data file belong and open the database but i don't know which tablespace he belongs to, so can u tell me how to know that

2.creat the same file at os lvl and do full database import

please help how can i open my db


regards

janakors
Re: ora-01110: data file 10 [message #423791 is a reply to message #423785] Mon, 28 September 2009 05:05 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Use DBA_DATA_FILES view to get tablespace name for specific datafile
Re: ora-01110: data file 10 [message #423880 is a reply to message #423785] Tue, 29 September 2009 00:34 Go to previous messageGo to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
hi

but my db is not open so i cant issue DBA_DATA_FILES as my db is at mounted stage as it6 can/t open, so how to nkow then


regards
Re: ora-01110: data file 10 [message #423885 is a reply to message #423880] Tue, 29 September 2009 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query v$datafile in mount state.

Regards
Michel
Re: ora-01110: data file 10 [message #424231 is a reply to message #423785] Thu, 01 October 2009 00:15 Go to previous messageGo to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
yes it worked

thank you sir and if u can guide me regarding the commands or select quries i can perform at MOUNT satge of database so i will update my knowledge. any links or document i can read i will be really thankfull.


regards


janakors
Re: ora-01110: data file 10 [message #424247 is a reply to message #424231] Thu, 01 October 2009 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Some v$ views are accessible in mount state.
There is no documentation on this point, these are views containing information from Oracle code itself (like v$transportable_platform) or from control file (like v$datafile).

Regards
Michel
Re: ora-01110: data file 10 [message #424275 is a reply to message #424231] Thu, 01 October 2009 04:16 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

It seems you need list of dynamic performance views

At the following documentation (in the 6th chapter) you can see the list of all Dynamic performance views

6 Dynamic Performance (V$) Views

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm
Re: ora-01110: data file 10 [message #424286 is a reply to message #424275] Thu, 01 October 2009 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not all v$ views are queryable in mount state.

Regards
Michel
Re: ora-01110: data file 10 [message #424391 is a reply to message #424286] Fri, 02 October 2009 01:21 Go to previous messageGo to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
yes sir u are correct. not all views but i know only V$datafile so only these two views as u said in your previous post or more then that. i mean some list or few important views u can tell so i will update myself as i didn't find some good on it

thank you


regards
Re: ora-01110: data file 10 [message #424393 is a reply to message #424391] Fri, 02 October 2009 01:33 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Have you checked the link which I've posted?
Re: ora-01110: data file 10 [message #424395 is a reply to message #424391] Fri, 02 October 2009 01:45 Go to previous message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
janakors wrote on Fri, 02 October 2009 08:21
yes sir u are correct. not all views but i know only V$datafile so only these two views as u said in your previous post or more then that. i mean some list or few important views u can tell so i will update myself as i didn't find some good on it

thank you
regards

Do it yourself: get a list of all V$ views (query dba_views), put your database in mount state, and query all previously listed views, then you will know all those that are queryable (and can put the list here to help others).

Regards
Michel

Previous Topic: media recovery not enabled
Next Topic: restore the data from rman
Goto Forum:
  


Current Time: Thu Sep 29 12:24:48 CDT 2016

Total time taken to generate the page: 0.22821 seconds